1

I've been struggling with the calculated column in SharePoint.

I would like to have a column in which the date is calculated from the values in two other columns. I have one column named "Status", a second column called "Requested Date" and a third column called "Lift Date".

If status is listed as "As Needed" or "Daily" I would like the Lift Date to show today's date, if the status shows "Not Started" then I would like Lift Date to show the Requested Date.

Any assistance would be greatly appreciated.

Briony
  • 11
  • 1
  • 1
  • 2

2 Answers2

1

You can also use Today() or Now() Above function also gives todays date

Monica Jagani
  • 3,836
  • 6
  • 32
  • 49
  • 1
    Today does not work in situations like this. Please read - http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/ – Ryan Feb 18 '16 at 20:16
  • More here: http://sharepoint.stackexchange.com/questions/151144/how-to-use-today-and-me-in-calculated-column/151336#151336 – Danny '365CSI' Engelman Feb 25 '16 at 10:11
0

EDIT:

Try this:

=IF([STATUS]="Not Started", [Lift Date], [TodaysDate])

Today isn't allowed in calculated columns, but there are ways to work around that:

Create a "TodaysDate" column and run a daily SharePoint workflow that sets today's date and pauses for a day. Then you can reference that column for any calculated columns that you may have.

Mike
  • 12,186
  • 8
  • 41
  • 64
  • Thank you! This is so much easier and it appears to be working properly. I might have been overthinking how to go about the formula... – Briony Nov 13 '14 at 17:53
  • @Mike where is the value of [Today] configured? Is it the regional settings we have in site administration or the settings we have in web application in central admin? – Vignesh Subramanian Jan 20 '16 at 08:58
  • That is based on your regional settings in central administration – Mike Jan 20 '16 at 13:45
  • @Mike Mike Mike - did you read that blog post (mine actually) that you quoted from? You've misquoted it and its actually explaining why those techniques DONT work. For avoidance of doubt - this DOES NOT AND HAS NEVER WORKED. – Ryan Feb 18 '16 at 20:16
  • Thanks Ryan, this was an older workaround in WSS, but was trying to get some reference for it. Guess we will have to use other means. – Mike Feb 18 '16 at 23:33
  • Hi Mike - it actually never worked properly, all the way back to WSS 2.0. There are lots and lots of blogs saying it does (and it appears to until you get to 'tomorrow' and [today] is now old) but it doesn't and never seems to have. All the best. – Ryan Feb 20 '16 at 14:55
  • Christophe allready debunked this [TODAY] trick way back in 2008. There are workarounds for display a Today calculation in a View: http://sharepoint.stackexchange.com/questions/151144/how-to-use-today-and-me-in-calculated-column/151336#151336 – Danny '365CSI' Engelman Feb 25 '16 at 10:10