Create multi-contact cell from a row array of individual contacts

I have a sheet as:

Header: SME1; SME2; SME3; All SMEs

Row 1: Bill Ross; Suzie Collins; Anne Doe; =join([SME1:SME3]@row)

Each of the SME columns is a contact. I want to fill my 'All SMEs' column with a formula which makes a multi-contact with all of the contacts joined together for easier filtering.

I've tried to write the formula as =join[SME1:SME3]@row, CHAR(10)) and a couple variants thereof. It's not working. Instead, it just joins the contacts as text instead of as contacts.

Please help! Thanks :D

Find more posts tagged with

Contacts

Formulas

Accepted answers

All comments

Bassam Khalil

Hi @Jonathan Valz

Hope you are fine, please check that all columns(SME1; SME2; SME3; All SMEs) type are "Contact List" then use the following formula:

=JOIN([SME1]@row:[SME3]@row, CHAR(10))

the following screenshot shows the result:

Jonathan Valz

Hi Bassam,

Thanks for the response. Unfortunately not what I'm looking for (multi-value contact cell).

My current formula gets me 'SME Grouped'

What I'm looking for is 'SME Grouped s/b'

e.g.

MarieM

Was there a resolution for this? I'm have the same problem

Genevieve P.

Hi @MarieM

Contacts cannot be joined together in a multi-select cell using a formula - they can be joined but the values will appear as Text. You'll need to have the multi-select combinations listed somewhere else as a reference that you can then bring back.

You may want to vote on the Idea post in our Product Feedback category, here:

https://community.smartsheet.com/discussion/97466/combine-contacts-from-multiple-columns-into-a-single-cell

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.