If Contains Contact Cell

I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have written looks like this:

If(Contains("John Smith", [Received By]@row), 1, 2). The result is always returning false ("2") even when the contact of "John Smith" is present. I can create a straightforward "IF" statement, but the contains portion is not working.

Find more posts tagged with

Formulas

IF(

Accepted answers

All comments

Michelle Choate 2

Try switching it to the email address. What happens then?

Or possibly try an IF(HAS()) instead. IF(HAS([Received By]@row, "John Smith"),1,2)

Ross Novotny

Thanks @Michelle Choate 2 , the "Has" formula worked. I had previously tried the email reference, but that does not work.

Jennifer Kurtz

Hi! I think you could cut out the "Contains" function and use =IF([Received By]@row="John Smith", 1, 2)

Does that work for you?

Paul Newcome

It wasn't working because the CONTAINS function just doesn't work well in general with contact type columns.

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.