Converting text to a numerical value
I suspect there is a very simple solution to this. My knowledge of formulas is minimal and I want to make sure I am setting things up to work as I want them to work. In the example below what I want to do is to assign a numeric value to each of the text responses. (Very low = 1, low = 2, etc.). I would do this in both emotion and entanglement component columns. Then I want to take the numeric values and add them together to get the complexity score. I would appreciate any help.
Help Article Resources
Check out the Formula Handbook template!