Joining multiple cell data whith in SmartSheets
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:
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?
Help Article Resources
Check out the Formula Handbook template!