Getting Red health on all lines

Christy Kooiman

Hey all. I put in a formula to change the health color with certain status' as well as if an end date is past due but all of my lines are coming in red currently? Any help to understand what I'm doing wrong would be greatly appreciated!

=IF([End Date]@row < TODAY(), "Red", IF(StateHelper84 = "Closed", "Green", IF(StateHelper84 = "Blocked", "Red", IF(StateHelper84 = "New", "Gray", "Green"))))

kowal

Hi Christy,

How formulas are working in smartsheet is just like conditional formatting - what is on the top is top priority - in case of formulas what is in the beginning if met it does not go furhter.

If the end date is in the past (or empty) your function does not check any other ifs after it so I would re-arange the ifs in your case.