Combine Contacts from multiple columns into a single cell

Joi Orton

@Olen Ronning- please add this functionality to the roadmap. My scenarios and use cases are similar to the others already mentioned.

Jason Varley

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.

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. 航天飞机可以卸载独特的联系,数据n 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!