Adding multiple contacts to a contact field with formula

cthrasher97141

Hello

I would like to add multiple contacts to a single contact cell for one task with a formula, is there a away to do this? Can Group Management be utilized?

Thank you

Andrée Starå

Hi,

Unfortunately, as far as I know, it's not possible at the moment with a formula or by using Groups, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

I do have an idea I'm going to test out and I'll get back to the post if it works out! Unfortunately, I don't think it will!

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

cthrasher97141

Thank you so much for the response, let me know your results. I am going to use a rule for now but I am not sure if it will do everything I am hoping.

Andrée Starå

Excellent! 

Happy to help!

I'll get back to you when I've tested it.

Sarah Brelage

Guys,

I need to do something similar. I want to send an alert to an entire team and thought I would create a contact cell to capture the 10 names. Unfortunately, it doesn't look like I'm able to do so. Have you had any luck creating a rule or another work around? The sheet is shared to alot of people outside of the team so I can't sent the alert to all who are shared to the sheet.

Paul Newcome

You would have to manually enter those 10 names. There is currently not a way to use a formula to populate multiple contacts into a cell.

Anna1

Has there been any traction on this issue? I would love for this to be something that gets rolled out so that every time we get a new employee, they can get added to all the necessary automations without being the sole recipient.

SmartMeet Solutions

@Andrée Starå & @Paul Newcome

Have either of you come up with a work-around for this?

I have a project where the stakeholder wants the employee name in the dropdown options for "Assigned To" instead of the email address (for a contact list). I'm trying to think of a formula or workflow that would populate the multi-select contact field based on what is selected in the multi-select dropdown field.

I've seen lots of questions about this, but no work-arounds, any luck?

Paul Newcome

@SmartMeet Solutions The only thing that works is setting a lot of somethings up so that every single variation is covered. Whether that be a lot of automations or a comprehensive reference list is up to you, but the reference list would have to look something like this for just 4 names.

Name 1

Name 1 / Name 2

Name 1 / Name 3

Name 1 / Name 4

Name 1 / Name 2 / Name 3

Name 1 / Name 2 / Name 4

Name 1 / Name 3 / Name 4

Name 1 / Name 2 / Name 3 / Name 4

Name 2

Name 2 / Name 3

Name 2 / Name 4

Name 2/ Name 3 / Name 4

Name 3

Name 3 / Name 4

Name 4

Then you can do a straight INDEX/MATCH. But as of right now there is no way to join multiple referenced cells into a single cell for functional email addresses.