Hi, can anyone help please.

I'm trying to change formula that changes the colours in the health column automatically when you change the drop down in State column such as complete, in progress. I would like to have the following

Green – not started

Yellow – in progress

Red – when it goes past the due date

Blue – Complete

There is already a formula in the smartsheet but I’m struggling to change it. Any help would be great. Thanks 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!