Average values assigned from health ball forumulas

Options

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!