Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated column only updates when list item is edited

  Asked By: Amrita    Date: Jul 24    Category: Sharepoint    Views: 11085

I have a calculated column, that uses [Today] in the formula. It works great
with the only exception that it will only update if the list item is edited. Is
there a way to have this be current at all times?

The formula is as follows, and yes it is a little complex.

Date]-Created<0,0,([Resolution Date]-Created)))

Basically, what I want the formula to do is check to see if the Resolution Date
column is blank. If it is, then I want it to calculate how many days between
today and the day that the list item was created, otherwise, if the Resolution
Date is not blank, I want it to calculate how many days between the Resolution
Date and the Date the list item was created. (The Resolution Date will be set
by a SPD workflow when another field is changed to a certain value.)



5 Answers Found

Answer #1    Answered By: Alexander Rocha     Answered On: Jul 24

This is by design. calculated  columns only update  when an item  is created  or
edited. the only way I know of to handle this involves creating a timer Job
programmatically that reads the list  items on a timed basis and updates  the
calculated column.

Answer #2    Answered By: Maggie Benson     Answered On: Jul 24

Do you have more details on how that would be accomplished? I would like to
have that calculated  column be current. It would be the only list  on the entire
Site Collection that requires it.

Answer #3    Answered By: Lane Trujillo     Answered On: Jul 24

Take a look at the following BLOG entry.


Answer #4    Answered By: Rafael Willis     Answered On: Jul 24

There is another possible solution (which doesn't require code) is:

Answer #5    Answered By: Richard Davis     Answered On: Jul 24

I agree with a comment that links to another article from that one. I went to a
lot of hassle to basically recreate the "modified" column. Kind of makes the
whole "[Today]" thing useless.

Didn't find what you were looking for? Find more on Calculated column only updates when list item is edited Or get search suggestion and latest updates.