Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Getting Red health on all lines
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"))))
Best Answer
-
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.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Answers
-
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.
Experienced IT PM and the Real Smartsheet Enthusiast.
Is there anything else we can help you with? - book your time.
MASA Consult - Your Aligned Smartsheet Gold Partner
Find us on LinkedIn & Check our Smartsheet Solutions!
Tag my name: @kowal if you want me to respond :)
Help Article Resources
Categories
Check out the Formula Handbook template!