Assign a value to text
I'm a newbie. I have an evaluation form where responses are Average, Very Good and Superior. I'd like to have another field in the smartsheet populate upon response with a numeric value. 5 for Average, 10 for Very Good, and 20 for Superior
Is it possible to do this using formulas or is there a way to assign a numeric value to text responses?