Combine individual Contact cells by formula



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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!