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
Check out the Formula Handbook template!