How do I concatenate contact names from different sheets?

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!

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

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

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking 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!

All comments

Christian Graf

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

Thank you @Christian Graf for 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å

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

User251

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

User251

@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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.