Trouble with Formula for RYG/Health/Status Columns

Hi There,

I'm brand new to Smart Sheet and still learning the abundance of inner workings - hoping to find some help with what is probably an easy formula but I can't seem to get it right!

I'm trying to change the color of the RYG ball under my 'Health' column based on the 'Status' column. For instance:

Red = Canceled/Not Started

Yellow = On Hold

Green = In progress

Complete = Blue

=IF([Status]1 = "In Progress"; "Green", IF(OR([Status]1 = "Not Started", [Status]1 = "Canceled"); "Red", IF(OR([Status]1 = "On Hold"; "Yellow")))

Thank you to any and all who can lend a hand in solving this mystery, most appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!