Converting text to number
I have a dropdown column with categories that I want to convert to numbers in another column.
For example, if the value in the dropdown column is "REPORT", then I want the other column to be the number "12". If the value in the dropdown column is "GO BACK", then I want the other column to be the number "5", etc.
I have three values in the dropdown column that I can select from. Based on what value I choose, I then need a formula to convert each value to a number in the subsequent column.
What formula(s) can I use to do this?
Answers

Nested IF
=IF(Dropdown@row = "REPORT", 12, IF(Dropdown@row = "GO BACK", 5, IF(Dropdown@row = "THIRD OPTION", 2)))
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!