Calculating an average confidence level

earl_bennett
earl_bennett ✭✭✭✭✭✭
edited 05/16/22 in Formulas and Functions

I'm creating a metrics sheet that collects the confidence level ( 1 through 10 ) by month. What I'm trying to figure out is how to calculate or identify the average confidence level received.

The diagram below shows that I have entries for confidence levels 7,8, and 10. How do I determine the teams confidence level is say... 8.5?

Thanks so much...

image.png


· Share on FacebookShare on Twitter

Best Answer

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!