If Status "Complete" how can I set it to automatically update the color on the RYGG balls?

Joy Durham

We would like to do conditional formatting or a function so that when the Status column is marked 'complete', it will automatically update the RYGG Ball color in the column next to it.  Does anyone know how to do this?

Atus Bartal

Joy,

check out Craig's answer in this thread: https://community.smartsheet.com/discussion/nested-if-formula

In short, you can set the color of the balls with an "IF" formula, for instance: 

=IF(Status1="complete","Green","Yellow) - it sets the ball green if the cell in the first row in "Status" column contains "complete", otherwise it will be yellow. You can put in a complex nested IF formula like Craig did, so there are lot of opportunities for ball-automation

If you need more help, please let us know. 

Atus

Kennedy Stomps

Great suggestion, Atus! We also outline how to do this in this article from our Help Blog: https://www.smartsheet.com/blog/support-tip-automate-RYG-balls. Let me know if you run into any difficulty implementing this in your sheets!

Atus Bartal

Yes, thanks, Kennedy, long time ago I did see that article. Really good explanation!

Joy Durham

Thank you both.  Will give it a try.