Survey Score Formulas



We are launching a customer satisfaction survey this week. When completed, they will want a dashboard showing results. We have 5 departments with 2 questions each. The scoring is shown in screenshot below.

I need to create a formula that will tally results and also give average score. My problem is that it's not just numbers. I'm assuming I will need a helper column for each question. Is it an "IF/Then" formula? Suggestions?

Darla Brown

What you meditate on, you empower!

Overachiever - Core Product Certified - Mobilizer - EAP

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!