Assign a value to text

Carolyn_HCarolyn_H
edited 12/09/19 in Formulas and Functions
11/27/19 Edited 12/09/19

Hi,

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?

Thanks! 

Carolyn

Tags:

Comments

Sign In or Register to comment.