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?
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.
