Combine individual Contact cells by formula

Ivan Tam

Hi,

I have 2 individual columns and they are with property "Contact". I would like to combine the contact values of these 2 columns and store them in the 3rd contact column, that means the 3rd column can store multiple contacts in the cells. Is there be a way to combine two individual contact cells into one cell with both contacts using a formula?

Thanks in advance.

Ivan Tam

Actually I submitted this case to Smartsheet support (case #: 05032421) but I haven't got any reply.

Genevieve P.

Hi @Ivan Tam

You can populate a multi-contact cell with another multi-contact cell in a one-to-one relationship, but it's not currently possible to bring in 2+ individual cells into one Contact cell as multiple values.

Please let the Product team know this is something you would find useful by filling in this form, here!

Thank you,

Genevieve

cjhagerman

@Ivan Tam , I know this response is months later, but it might help others too. I was just trying to figure out a way. This sort of worked: =[contact column 1]@row + ", " + [contact column 2]@row . Unfortunately, once combined, the cell doesn't recognize the emails as "contacts" within Smartsheet though. It simply shows a list of email addresses.

A.J.

I know this is an old thread, but replying to @Genevieve P. , is there a way to grab every contact in a column then have them combined into a single cell so I can have that combined list appear on another sheet via sheet linking?

Andrée Starå

Hi @A.J.

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

A.J.

@Andrée Starå , I asked about this in 4 different places during Engage. You were right! Not possible currently.