RYG Ball Automation


I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible.

Essentially, my overall goal is to automate the RYG ball based on how 26 other fields are answered --

13 or less are green = Red

14-19 Green = Yellow

20-26 Green = Green

Is this possible?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!