I'm trying to add a column to a table I created in SharePoint. I want the column to do the following: Given the status of an action e.i. due or over due, calculate the number of days that the action has been raised. So I wrote a formula to calculate this taking the values from the column Date Raised and today's date.

=IF(OR([Status]="Overdue",[Status]="Due"),DATEIF([Date Raised],[Today],"d"))

When I click the OK button I get

Sorry, something went wrong The formula contains a syntax error or is not supported

I would appreciate if someone could point out what I'm doing wrong


I read other posts and I managed to solve the problem. By using today() the formula would be:

=IF(OR(Status="Overdue",Status="Open"),(TODAY()-[Date Raised]),"")

It worked perfectly throughout the entire table


Using the Today() Function is exactly the same as using [Modified]

Because SharePoint Formulas only re-calculate the Formula when:

  • the Item is updated

  • or the Formula itself is edited

So you daily check does not work.

Details and workarounds to do Today calculations in Views: How to use Today and Me in Calculated column

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.