How to Combine two cells
I am trying to combine the Last Name and First Name column.
Please see the formula that I used below:
=[Last Name]@row + "," [First Name]@row
Answers
-
Try adding another plus between the comma and the second column reference.
=[Last Name]@row + "," + [First Name]@row
-
Perfect this worked.
Now I am struggling to pull in the emails from another sheet.
I used the formula below:
=IFERROR(INDEX({Copy of Master DPS Directory Range 1}, MATCH([Full Name]@row, {Copy of Master DPS Directory Range 2}, 0)), "")
-
Formula looks good @Louis.Smith
What is it doing or not doing? Is there an error, or it is just not matching?
Make sure the range you have called Copy of Master DPS Directory Range 1 contains the email addresses and Copy of Master DPS Directory Range 2 contains the names in exactly the same format (i.e. surname comma firstname).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!