Contains formula?

Topic Labels: Formulas
692 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi All,

In the formula:

IF(AND({Approved} = 1, OR({Project Manager} = “John Doe”, {Assigned Staff} = “John Doe”)), “true”)

I’m trying to figure out how to change the = to contains. For example, Assigned Staff is a Collaborator Field and might contain multiple collaborators. In the formula above, it only works if “John Doe” is the only name in the field. I’m trying to figure out how to write the formula so that it looks for any name in the Assigned Staff field with “John Doe”.

Thank you!

0 Replies 0