Trouble with Formula for RYG/Health/Status Columns
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!