How to make the health column mark red if Actual End date> Today using the column formula
I have health column where I am managing the status of completed, in progress and planned with Green, Yellow and blue color respectively. Whereas I also nested the IF AND in same column if the Actual End Date> today and the status is On-Hold then the health column should be automictically be red. This is the formula.
=IF(Status@row = "Completed", "Green", IF(Status@row = "In Progress", "Yellow", IF(AND([Actual End Date]@row > TODAY(), Status@row = "On-Hold"), "Red", IF(Status@row = "Planned", "Blue", ""))))
Help Article Resources
Check out the Formula Handbook template!