Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If Status "Complete" how can I set it to automatically update the color on the RYGG balls?
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?
Comments
-
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
-
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!
-
Yes, thanks, Kennedy, long time ago I did see that article. Really good explanation!
-
Thank you both. Will give it a try.
