I have a SharePoint List that I need to build a calculated column for but am having issues trying to put together the formula.

For the purpose of this forum, the columns needed in the formula are "Date1", "Date2", "Column1" & "Column2". The calculated column is called Status and I want it to return 'Red', 'Amber' or 'Green'.

The criteria is below:

Date1 is more than 365 days ago from today

Date2 is less than 90 days away from today

Column1 = Yes AND Column2 = Yes AND (Date1 is less than 365 ago from today OR Date2 is more than 90 days away from today)

1 Answer 1


Is the color you need the color of this column value or the background color? Or just want to return the color of the word itself? If it is the former, it is recommended that you use column formatting to achieve it. Reference:


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.