Is One Of (multiple contacts) field

palmcitytim

I have looked around and could not locate help for this question. I have a contacts field and it is configured to allow multiple people. How do I write an If statement to pick up a match to some other column having one of their names? Thanks much!

Genevieve P.

Hi @palmcitytim

If you're searching for one value within a multi-select cell, you can use the HAS function!

For example, something like this:

=COUNTIF({Multi Select Column}, HAS(@cell, [Single Name]@row))

If this hasn't helped, it would be useful to see a screen capture of each sheet, identifying what you're looking to do, but please block out sensitive data.

Cheers,

Genevieve

Genevieve P.

Hi @palmcitytim

If you're searching for one value within a multi-select cell, you can use the HAS function!

For example, something like this:

=COUNTIF({Multi Select Column}, HAS(@cell, [Single Name]@row))

If this hasn't helped, it would be useful to see a screen capture of each sheet, identifying what you're looking to do, but please block out sensitive data.

Cheers,

Genevieve

palmcitytim

Thank you for that Genevive!