Join Collect Formula not pulling contact info

I have a formula pulling contacts from one sheet to another that is working HOWEVER, it's not pulling them over as a contact with their emails attached and I have automations set up for email reminders and they won't be delivered because its not an email and just a name.

Both columns are contact columns btw and everyone's name has been added as a contact.

What am I doing wrong??

Formula and screenshots below for reference…

=JOIN(COLLECT({Participant Email}, {Module}, Module@row, {Modules}, Modules@row, {Start Date}, [Finish Date]@row, {Control ID#}, [Control ID #]@row), CHAR(10))

Find more posts tagged with

Formulas

Accepted answers

All comments

Shanky Paul

I think the Index (Collect) formula can fix this. Try the below formula:

=INDEX(COLLECT({Participant Email}, {Module}, Module@row, {Modules}, Modules@row, {Start Date}, [Finish Date]@row, {Control ID#}, [Control ID #]@row), 1)

Tiffany Castro

PERFECT!! This saved me, thank you! How do I make it so it pulls multiple contacts if that is the case?

Ryan Catling

I have the exact same problem (using Join to list multiple contacts) please advise!

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.