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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!