How do I concatenate contact names from different sheets?

User251 · 04/28/22

How do I add a contact name from a sheet to a cell in another sheet that has already other names?

For instance in sheet 1, column 1, I have Person One and in column 2, I have Person Two and Person Three. How do I add the 3 names to another sheet in one cell?

Thanks!

Andrée Starå · 04/30/22

Hi@User251

I hope you're well and safe!

To add to Christian's excellent advice/answer.

Unfortunately, it's not possible now to combine multiple contacts with a formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Christian Graf · 04/28/22

This is for if you have a column of names and want distinct ones.

=JOIN(DISTINCT({Contact (Sheet1)}), " & ")

If this isn't the answer can you share an image? It's hard to follow a text explanation.

User251 · 04/28/22

Thank you@Christian Graffor your reply.

Here is a screenshot of what I mean: I have 2 columns with contacts in Sheet 1 below. I need the contacts columns in sheet 1 to be separate because each column is used for a different purpose.

I want to be able to add the 3 contacts in one column in the second sheet below. I want to make sure that when my contacts in sheet 1 change, they automatically change in sheet 2.

Thank you.

Andrée Starå · 04/30/22

Hi@User251

I hope you're well and safe!

To add to Christian's excellent advice/answer.

Unfortunately, it's not possible now to combine multiple contacts with a formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

✅我的帖子(s) help or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

User251 · 05/03/22

Thank you@Andrée Starå. That was helpful. I will submit an enhancement request. I think adding the feature will be very helpful.

User251 · 05/03/22

@Christian Graf. The formula you suggested works very well with columns that have any type other than Contact List. I get the error "#INVALID DATA TYPE" when I use it with 2 contact list columns. I submitted a request for improvement to the Smartshee team.

How do I concatenate contact names from different sheets?

Best Answer

Answers

Help Article Resources

Categories