Go 4 Sharepoint

Search:

Welcome: Guest!

Sharepoint Forum

Home » Forum » Sharepoint

Ask a question

RSS Feeds

Calculated column only updates when list item is edited

Asked By: Amrita Bunha Date: Jul 24, 2009 Category: Sharepoint Views: 675

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.)

Tagged:calculated column only updates when list item is edited

5 Answers Found

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

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, 2009

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, 2009

Take a look at the following BLOG entry.

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

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

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, 2009

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.