Combine Contacts from multiple columns into a single cell

My use case here is to group team members (linked in from our team sheet) so I can create one group in a cell and have that populate as a group when selecting roles to approve a proof. At the moment I can only select individual roles. As an additional point, it would be useful if we are able to de-select users assigned to proofs, as users change roles, move out of the organisation etc.

Hi @Daniel Miller

I hope you're well and safe!

You could use a filter instead in the sheet, so if it's the current user in either of the columns, it will work to keep it in one Dynamic View. I just set this up for a client with multiple contacts on a record that should be able to access it.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and content is not always static as people change roles (email x may be changed to email y tomorrow).

Sheet B has an automation to request an update.

How does Sheet B sent the request to all the email addresses in Sheet A?

Following discussion with Pro Desk: "This will be an enhancement request to be able to pull the contacts into another sheet and display it as contact list."

1. We have a changing list of 9-12 contacts (email addresses) in sheet A (contacts column)
2. Data shuttle offloads unique contacts, then uploads them to a holding sheet B (we tried both text and contact column types)
3. A formula in sheet C (contacts column) joins the contacts from sheet B into one cell per row
4. An automation in sheet C sends an alert to the contacts in that contacts column cell when a row is changed.

The problem is, the joined contacts are text, not contacts, and no alerts get sent.

The formula =join({contact list}, char(10)) was used. We also tried =join({contact list}, char(44)). Neither formula converted the list of email addresses to contacts that the automation would recognize.

Please consider how we pull a list of contacts from sheet into one cell in another sheet so that automated alerts can be sent.

Thank you!

If this post is still going, I am happy to share a solution that I created this week using two sheets a JOIN(COLLECT( formula, and a data shuttle to achieve multiple contacts in one cell that preserves the contact as a real contact.

@Cleversheet Sheet A contains the email addresses of teachers in our schools, along with their respective school names. Sheet B, on the other hand, lists the names of the schools. In Sheet B, I utilize the JOIN(Collect) formula, referencing the school name column and Sheet A, to consolidate the email addresses of teachers for each school. It's important to note that the column used for the join(collect) formula must be a text column to collect multiple email addresses.

In addition to the text column used in the join(collect) formula, create a multi-contact column. This is where the offload data shuttle and upload data shuttle come into play. The offload data shuttle is responsible for offloading Sheet B as an attachment to itself, capturing the multiple email addresses per school. The upload data shuttle is triggered by a sheet attachment and maps the school name column and multiple emails to a multi-contact column.