Hi, I have a column that has a drop down box that has different options: Very Low, Low, Medium, High, Very High.
I have set up a substitute formula in a new column that replaces the above phrases with a number: Very Low = 1, Low = 2, Medium = 3, High...