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?
Answers
-
@Tina Rustvold Would a Sheet summary work? Or using a report to average the columns?
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
Check out the Formula Handbook template!