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.

1

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

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.

  • 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 8: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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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