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, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 68K Get Help
- 474 Global Discussions
- 209 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 85 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!