Joining multiple cell data whith in SmartSheets

212711649

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?

David Ruff

You can join cells in Smartsheet by using the plus sign: =A1+", "+B1

Hope this helps!

David Ruff

You can join cells in Smartsheet by using the plus sign: =A1+", "+B1

Hope this helps!

212711649

That works great! Thank you!