Searching for a value in a multiselect column

I probably should be going to bed, but I'm going nuts trying to figure out one last formula.

I have a sheet with a multiselect column named "Project Type".

The column has the following values:

Revenue Opportunity

Revenue Loss Avoidance

Risk Compliance

Cost Saving

I am trying to create a formula along the lines of:

IF Project Type CONTAINS "Risk Compliance" OR CONTAINS "Revenue Loss Avoidance" Then ...., Else ....

For the life of me I just can't get it to work....

Hoping someone can help me out of a jam.

Thanks

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!