Join distinct collect with contains

Can someone help with this formula? Its not working as-is, but I also would like to use the "contains"/"has" for the leader column as I combined a bunch of contact columns.

Here is my attempt to use has -

Heres the references (other sheet)

Month, all Leads, and R&B prog is the first one (project)

Find more posts tagged with

Formulas

Accepted answers

Lauren Y

well, something was up with a reference and not sticking… for those looking in the future, contains was better than HAS as it was able to search in the string of text.

All comments

Lauren Y

well, something was up with a reference and not sticking… for those looking in the future, contains was better than HAS as it was able to search in the string of text.

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.