Help with RYG Balls - Looking for an Average

Help with RYG Balls - Looking for an Average

Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that has linked in RYG balls for health from another sheet. There are three sections, with parent child relationships on each section. I would like to calculate an average for the health of each of the three sections to determine the overall health of each. Any suggestions? TIA!

Best Answers

  • edited 03/13/20 Accepted Answer

    Hi Paul.

    I would definitely need an average. This is needed to provide an accurate status for the whole.

  • Accepted Answer

    Hi Paul,

    Thank you so much! That did help. :)

    Laurie Bearden


  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Do you want an average, or would you want something more along the lines of if there is even 1 red, then turn the parent red. If there are no reds and at least one yellow then turn the parent yellow?

    I ask because taking an average could end up displaying a green on the parent row even though there is a red in one of the child rows.

    Both options can be accomplished.

Sign In or Register to comment.