# 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!

• ✭✭✭✭✭✭

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")))

10xViz.com

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?

10xViz.com

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")))

• Its not working and i am getting error

• ✭✭✭✭✭✭

@Bhavik Mishra Do you have a column in your sheet called "Status"?

10xViz.com

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?

10xViz.com

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")))

10xViz.com

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.

10xViz.com

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!