RYG Balls average

edited 12/09/19 in Formulas and Functions


i am looking to find a way to do an average with the RYG balls. 

ex: 2 green, 2 yellow, 2 red should have should show yellow ball for the overall project. 

is this something possible? 

thanks for your help


  • Mikey
    Mikey ✭✭✭✭

    I can't help you with the method, but can I offer some thoughts?

    When rolling up status (which isn't a great plan anyway), I always use the worse indicator rather than average.

    e.g. if your project has 1 red indicator, it overrides 999 greens or yellows and I'd be reporting the overall status as red because you have an activity which isn't going to make it.

    May be better to report on the number of reds, yellows and greens separately?

    Not sure what metrics you are using or how you have defined RYG so happy to wind-my-neck-in if necessary!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!