Joining multiple cell data whith in SmartSheets

Hi folks,

In excel, I usually have one column listing an employees last name, and another column listing the employee's first name. I often use a formula like this to join the 2 cells together:

=A1&", "&B1

where A1 is the Last name and B1 is the First name.

The results would be something like this: Last, First

Can I do this in SmartSheets? If so, what's the formula I need to use?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!