Reference a contact in IF formula

KirstineKirstine ✭✭✭✭✭
07/20/21
Accepted

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", [email protected]), true, "")

=IF(CONTAINS("<[email protected]>", [email protected]), true, "")

=IF(CONTAINS("[email protected]", [email protected]), true, "")

=IF(CONTAINS("Joe Bloggs <[email protected]>", [email protected]), true, "")

Best Answer

Answers

  • Nic LarsenNic Larsen ✭✭✭✭✭
    Accepted Answer

    Try this:

    =IF(FIND("Joe Bloggs", [email protected]), 1)

  • Nic LarsenNic Larsen ✭✭✭✭✭

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

    =IF(COUNTIF([email protected], FIND("Joe Boggs", @cell) >= 1), 1)

  • KirstineKirstine ✭✭✭✭✭

    Thanks so much! x

  • KirstineKirstine ✭✭✭✭✭

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

Sign In or Register to comment.