How do I concatenate contact names from different sheets?

User251 ✭✭
edited 04/28/22 in Formulas and Functions

How do I add a contact name from a sheet to a cell in another sheet that has already other names?

For instance in sheet 1, column 1, I have Person One and in column 2, I have Person Two and Person Three. How do I add the 3 names to another sheet in one cell?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!