Average values assigned from health ball forumulas
We need to average 4 columns that utilize Harvey balls to determine an overall project score. We added helper columns with a column formula that would assign a value to each rated criteria (budget, time, scope, quality):
=IF(Budget@row = "Blue", "5", IF(Budget@row = "Green", "4", IF(Budget@row = "Yellow", "3")))
Is there a way to then avarage these 4 helper columns without createing more? Right now we have added separate =Value columns and average those. Or can you somehow just average the Harvey balls and then determine the value of that ball on the average total? I can't get my brain there but seems there should better way...any suggestions?
Help Article Resources
Check out the Formula Handbook template!