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!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!