Join Collect Formula not pulling contact info

Tiffany Castro

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))

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!