Need help with Health Status Formula

ccousineau ✭✭✭
edited 10/18/23 in Formulas and Functions

I have a sheet with 3 columns: Action, Status, Health

I want the health to populate a green, red, yellow, or gray circle depending on which status the action is in. The status and corresponding health colors are:

Blank = Red

Not Started = Red

In progress = Yellow

Completed = Green

Cancelled = Gray

On Hold = Gray

Looking for a formula that allows all of the above to be true!

Thanks so so much!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!