Contains formula?

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!

1 Like