SharePoint List Calculated formula

Posted on 2013-09-27
Medium Priority
Last Modified: 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?
Question by:bbresslin
1 Comment
LVL 44

Accepted Solution

Rainer Jeschor earned 2000 total points
ID: 39527525
this will not work.
The TODAY function result is only evaluated once the item is written (so create or update) - not dynamically.
Your only option would be to use either a Powershell script or a coded Timer Job or a web service call with batch updates to re-calculate the difference.


Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question