Survey Results Word needs to be changed to number to quantify
Good morning,
I am currently working on a survey where the questions used words instead of numbers. I need to change the results from the words to a numerical value.
Example: Excellent= 5, Good=4, Fair= 3, Poor= 2, Very Poor = 1
Thank you!
Answers

Hi Kristin,
I would suggest you use a helper column for each survey question. Next to each question's column, enter the following:
=if(Q1@row="Excellent",5,if(Q1@row="Good",4,if(Q1@row="Fair",3,if(Q1@row="Poor",2,if(Q1@row="Very Poor",1,"")))))
(Where Q1 is the name of my question column.)
Hope this helps!
Best,
Heather

@Heather D This is how I did it, is this correct?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!