Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts

Paul Newcome

I (prematurely) set up a thread surrounding this that details everything including a screenshot as proof that it does work (sort of). Feel free to add to it if you come up with anything.

https://community.smartsheet.com/discussion/82311/formula-to-populate-multiple-usable-contacts-in-a-single-cell

Paul Newcome

@Kayla So it looks like we are back at square one unfortunately. My only suggestion at this time would be to create a list of every possible variation, and then you would be able to use an INDEX/COLLECT. The downside... Depending on how many variations you could have, that could turn out to be an absolutely massive list to manage.

Kayla

@Paul Newcome - THANK YOU for your help! I do hope Smartsheet will figure this one out soon -- it sounds like it would be helpful to a lot of us. I'll play around with some options to get around this in the meantime.

Paul Newcome

Sorry I couldn't be of more help. Please don't hesitate to Submit a Product Enhancement Request when you have a moment. The more that are submitted, the more they know we want this feature.

Interestingly enough, even though they are showing as text values, automations can still send to those cells that only have one contact in them.

LizTo

@Paul Newcome and @Bassam Khalil

Do you know if there have been any updates or developments on this since 2021? Having join collect result in usable contacts instead of text email address would be immensely useful. I'll submit a Product Enhancement Request, too.

kcollins

@Paul Newcome Did you ever find a consistent solution here?