Logo 
Search:

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: 11456

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.

=IF(ISBLANK([Resolution
Date]),IF(Today-Created<0,0,Today-Created),IF([Resolution
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.)

Share: 

 

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.

www.andrewconnell.com/.../...arePointTimerJobs.asp\
x

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

There is another possible solution (which doesn't require code) is:
blogs.msdn.com/.../552314.aspx

 
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.




Tagged: