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(Status@row = "Complete"; "Blue"; IF(Status@row = "In Progress"; "Green"; IF(Status@row = "On Hold"; "Yellow; "Red")))
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
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!
-
Are you able to post a screenshot of the formula actually in the sheet similar to my screenshot below?
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
=IF(Status@row = "Complete"; "Green"; IF(Status@row = "In Progress"; "Yellow"; IF(Status@row = "Needs to be done";"Red")))
I tired please see below:
-
Its not working and i am getting error
-
@Bhavik Mishra Do you have a column in your sheet called "Status"?
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
Yes sir i have a status column in my sheet.
-
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?
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
Its actually called Status and i tried both semicolon and coma but still getting same error.
-
Try this...
=IF(Status@row = "Complete", "Green", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Needs to be done", "Red")))
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
-
wow, its worked and thank you so much for your help.
-
Happy to help. 👍️
Looks like it was commas vs semicolons.
Come see me at ENGAGE 2023! I have "Happy to help 👍️" buttons!
If you can't find me roaming the floor, I will most likely be at the 10xViz Partner Booth.
Help Article Resources
Categories
Check out the Formula Handbook template!
