SharePoint Calculated Column Formula - Help!

Brass Contributor

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

 

For the purpose of this post, 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' based on the criteria is below:

 

Red
Date1 is more than 365 days ago (from today)

 

Amber
Date2 is less than 90 days away (from today)

 

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

0 Replies