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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!