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
Help Article Resources
Check out the Formula Handbook template!