Numeric and text formula

Options

I would like to use a numeric and text dropdown but calculate the numeric in another column. Below is the best I can come up with (doesn't work)


=VALUE(Impact@row(1 No Significant Impact))*VALUE(Likelihood@row(1 Extremely Rare))


Impact

1 No Significant Impact

3 Limited Negative Impact

4 Major Negative Impact

6 Serious Negative Impact

9 Catastrophic Negative Impact


 Likelihood

1 Extremely Rare

2 Rare

3 Unlikely

4 Possible

5 Likely

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!