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
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!