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 Loss Avoidance
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.
Help Article Resources
Check out the Formula Handbook template!