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.

2 Answers 2


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



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.

  • 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, 2014 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? Jan 20, 2016 at 8:58
  • That is based on your regional settings in central administration
    – Mike
    Jan 20, 2016 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, 2016 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, 2016 at 23:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.