Automating Status Balls to Showcase Overall Health
I am hoping to find a formula that will show the g/y/r status balls "overall health" based on the percentage of green, yellow or red balls in the column. Is there a way to "average" that? For example, if we have an equal amount of red and green balls the overall status ball would show yellow.
Thanks in advance