Is there a CONTAINS alternative for Contact formatted cells?

Goal: Count the number of times a name is mentioned.

Assigned to is multiple contact column

Name is a contact column

=COUNTIFS({P & A - Assignments List | Assigned To}, CONTAINS([Name]@row, @cell))

Is there a CONTAINS alternative for Contact formatted cells?

Find more posts tagged with

Accepted answers

Carson Penticuff

Yes, you are looking for the HAS() function.

https://help.smartsheet.com/function/has

=COUNTIFS({P & A - Assignments List | Assigned To}, HAS(@cell, [Name]@row))

All comments

Carson Penticuff

Yes, you are looking for the HAS() function.

https://help.smartsheet.com/function/has

=COUNTIFS({P & A - Assignments List | Assigned To}, HAS(@cell, [Name]@row))

The HAS function works for contact type data when you are looking for an exact match. If you are looking for a partial match (such as just last name or something like that), you would use the FIND function.

https://help.smartsheet.com/function/has

https://help.smartsheet.com/function/find

.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.