Using IF and CONTAINS in one formula
I am trying to create a formula that returns:
Tolerable if the answer is Low
Tolerable if the answer is Medium
Acceptable if the answer is High
Acceptible if the answer contains Urgent.
I need to figure out how to use "CONTAINS" because some answers have dashes and other things that mess up the formulas.
=IF(Answer@row = "Yes", "Acceptable", IF(Answer@row = "No", "Undesirable", IF(Answer@row = "Not Applicable", "Tolerable", IF(Answer@row CONTAINS "Urgent", "Acceptable))))
I am getting lost at the "CONTAINS" part.
Help Article Resources
Check out the Formula Handbook template!