Average Health Bubble from Multiple Project Health Bubbles
I have a portfolio dashboard for my PMO team and all of their projects. I use a metrics sheet to drive calculations for all projects. I am stuck on one thing and I need some help! I have formulas to calculate the main health bubbles for each from R, Y, G these come into a count:
What is the best way to average these up and get a portfolio health bubble?
Help Article Resources
Check out the Formula Handbook template!