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

Answered - Pending Review

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


  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 03/31/21

    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:

    PMP Certified

    [email protected]

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • edited 03/31/21

    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'


Sign In or Register to comment.