Reference a contact in IF formula

Kirstine

I'm trying to return a value of "TRUE" in a tick box column if a contact referenced in the same row is a specific person. It's a multiple contacts column too but I've done dummy runs with only one contact and it still won't work. I've tried the following and they don't work, what am I doing wrong? 😞

=IF(CONTAINS("Joe Bloggs", Team@row), true, "")

=IF(CONTAINS("<joebloggs@outlook.com>", Team@row), true, "")

=IF(CONTAINS("joebloggs@outlook.com", Team@row), true, "")

=IF(CONTAINS("Joe Bloggs <joebloggs@outlook.com>", Team@row), true, "")

Nic Larsen

Try this:

=IF(FIND("Joe Bloggs", Team@row), 1)

Nic Larsen

Try this:

=IF(FIND("Joe Bloggs", Team@row), 1)

Nic Larsen

I found an error in original formula with multiple contacts, try this one instead:

=IF(COUNTIF(Team@row, FIND("Joe Boggs", @cell) >= 1), 1)

Kirstine

Thanks so much! x

Kirstine

The first one is working for me in cells where my contact is alone and in ones where he's not!