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?
Help Article Resources
Check out the Formula Handbook template!