Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
If then statement for Risk Management Matrix
Hi Folks 
I'd like to feedback to write a formula that evaluates the following:
=IF(Cell A1 "Acceptable" then???
Acceptable
Tolerable
Undesirable
Intolerable
"Then"...
the statement should take the word "Acceptable" and give it a value of 1, repeating this same evaluation such that "Tolerable" receives a value of 2, "Undesirable" receives a 3 and finally Intolerable receives a 4. Note: The severity is a drop down list so I need the statement to have all 4 words and values associated.
What I plan on doing is then taking the severity scores and repeating it with likelihood.
Thank you!
Comments

Hi,
I just wrote the following but I called my dropdown column of Rating, so you'll see "Rating1" as the cell reference instead of "A1".
=IF(Rating1 = "Acceptable", 1, IF(Rating1 = "Tolerable", 2, IF(Rating1 = "Undesirable", 3, IF(Rating1 = "Intolerable", 4, ""))))
That will give you two columns as in the screenshot attached:
 One with the text: Acceptable, Tolerable, etc.
 The other with the score: 1; 2; 3; or 4
Is that what you meant?

Thanks Paul. This is perfect!