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?