Combine Contacts from multiple columns into a single cell

Joi Orton

@Olen Ronning-请将此功能添加到路线图。我的scenarios and use cases are similar to the others already mentioned.

Jason Varley

我的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.

Daniel Miller

I have two columns, Supervisor and Task Owner. There are many times where a Supervisor can also be a Task Owner. I would love to create a helper column that combines that row's Supervisor and Task owner in one multi contact column. Throw that in a report and make a Dynamic View and "Restrict view by current user" and I have a single Dynamic View for showing my internal clients their responsibility.

Since that can't be accomplished, I have to provide two Dynamic Views. I'm from Wisconsin... even I think that is cheesy!!

Andrée Starå

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

✅了我的帖子(s)帮助或回答你的问题吗tion or solve your problem? Please support the Community bymarking 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!

Cleversheet

@Andrée Starå

Andrée, the inability to populate a multi-contact column by formula continues to necessitate all sorts of workarounds, and I infer your suggestion to@Daniel Milleris one of them.

I assume the filter would be an OR setup that would in effect blend two or more Contacts columns. I'll give that a try.

Troy

SPBops

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?

JLen

Adding another request for multi-contact column by formula!!! This is a huge need for so many use cases! Please add this to the roadmap!!!!!

SPBops

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!