Assign a value to text
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
Comments
-
Hi Carolyn,
Try something like this.
Change the Result name to your column name.
=IF(Result@row = "Average"; 5; IF(Result@row = "Very Good"; 10; IF(Result@row = "Superior"; 20)))
The same version but with the below changes for your and others convenience.
=IF(Result@row = "Average", 5, IF(Result@row = "Very Good", 10, IF(Result@row = "Superior", 20)))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
To add:
If you only have those three options, we can simplify it like this.
If it's not Average or Very Good, it's Superior.
=IF(Result@row = "Average"; 5; IF(Result@row = "Very Good"; 10; 20))
The same version but with the below changes for your and others convenience.
=IF(Result@row = "Average", 5, IF(Result@row = "Very Good", 10, 20))
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!