Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Survey Score Formulas
Hi!
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
-
Yes. You will need a helper column. But as long as your scores are single digits and always the leftmost character, you can use...
=VALUE(LEFT([Column Name]@row))
This will give you numbers you can average. Then to get a tally, you would use a COUNTIFS.
Answers
-
Yes. You will need a helper column. But as long as your scores are single digits and always the leftmost character, you can use...
=VALUE(LEFT([Column Name]@row))
This will give you numbers you can average. Then to get a tally, you would use a COUNTIFS.
-
Yes! I was trying to do a multiple IF statement, but this works and is cleaner!
Thanks, as always, Paul!
Darla Brown
What you meditate on, you empower!
Overachiever - Core Product Certified - Mobilizer - EAP
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.7K Get Help
- 473 Global Discussions
- 201 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 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!