Join Collect with text

bncole21

Join Collect is a new one for me and I am struggling...

I am wanting to JOIN COLLECT with results only with BFF PM, listing the contact name/card

Master sheet:

Current formula:

=JOIN(COLLECT({Area Contact Range 2}, {Market Area}, [Market Area]@row, {Title}, "BFF PM"), " , ")

Reference:

Find more posts tagged with

Cell linking

Accepted answers

All comments

Genevieve P.

Hey @bncole21

I see that your "other title" column is a multi-select column. In this case, you'll want to use the HAS Function to say that if the cell has that specific selection (e.g. "BFF PM") then bring back other data.

At this point, it's looking for an exact match, meaning "BFF PM" cannot have any other selections with it.

Try this:

=JOIN(COLLECT({Area Contact Range 2}, {Market Area}, [Market Area]@row, {Title}, HAS(@cell, "BFF PM")), " , ")

Cheers,

Genevieve

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.