SharePoint List Calculated formula
Posted on 2013-09-27
We have a SharePoint list that has a column "Open Deal Age" which is supposed to be a calculation of the opportunity start date to the current date. (Opportunity Date is another column in the list) The calculation does not seem to be flowing each day. For example:
Opportunity Date 9-24-2013, the open deal age should have a value of "3" today which if I go in and create this item today it will reflect this accurately, however tomorrow it will still show a value of "3" it should show "4" of course. If I go in tomorrow and edit the item and not make any changes, and simply click ok while in the item..it will update to "4" however we need this to be an automated process rather than going into each item every day.
Do you see any issues with the below calculated formula?
=IF(Status<>"CLOSED WON",Today-[Opp Date]+1,"")
Is there a workaround for this, or any known problem that this wouldn't update?