I am trying to create a list that has three columns. There is a dropdown, so the users can choose whether something is "High", "Medium", or "Low". I want to be able to have these choices equal a number for example
"High" = 3.
The final goal is to be able to have a fourth column be able to multiply the values from the first three columns while retaining the words. So the formula for column 4 would be
[(Column 1*Column 2*Column 3) = #].
Is this possible?