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!
Answers
-
You are actually pretty close. Try something like this...
=IF([email protected] = "Complete"; "Blue"; IF([email protected] = "In Progress"; "Green"; IF([email protected] = "On Hold"; "Yellow; "Red")))
thinkspi.com
0 -
Hi Paul,
Thank you so much for your help! I tried implementing this morning and I get an error...#UNPARSEABLE?
Perhaps I am inputting into the wrong cell/column? Hopefully this screen shot helps. Truly appreciate your help!
0 -
Are you able to post a screenshot of the formula actually in the sheet similar to my screenshot below?
thinkspi.com
1 -
=IF([email protected] = "Complete"; "Green"; IF([email protected] = "In Progress"; "Yellow"; IF([email protected] = "Needs to be done";"Red")))
I tired please see below:
0 -
Its not working and i am getting error
0 -
-
Yes sir i have a status column in my sheet.
0 -
Is it actually called "Status" or is it called something else? Do you normally use the semicolon in between sections of a function or do you normally use a comma?
thinkspi.com
0 -
Its actually called Status and i tried both semicolon and coma but still getting same error.
0 -
Try this...
=IF([email protected] = "Complete", "Green", IF([email protected] = "In Progress", "Yellow", IF([email protected] = "Needs to be done", "Red")))
thinkspi.com
0 -
wow, its worked and thank you so much for your help.
0 -
Happy to help. 👍️
Looks like it was commas vs semicolons.
thinkspi.com
0