Join Collect with text
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:
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 495 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!