Reference a contact in IF formula

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, "")

Find more posts tagged with

Contacts

Formulas

functionality

Accepted answers

Nic Larsen

Try this:

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.