IF statement to update "Health" column base on "State" and "End Date"

Hi everyone,

I'm trying to create a formula that: If state is not complete and end date is in the past, then health column will show ⏰

State - Drop Down menu: Complete, In Progress, At Risk, Blocked, Not Start

Thank you in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!