Forum Discussion
Sam1209
Sep 04, 2023Brass Contributor
SharePoint Calculated Column Formula - Help!
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)
No RepliesBe the first to reply