Text Join Columns with a row range
Hi there-
I want to Join collect the Email column(Contact field) and the Palo Alto Additional Emails column(Contact field) together with the ranges of rows 47-49
The first part of my formula worked:
=JOIN(COLLECT(Email47:Email49, Email47:Email49, <>""), ", ")
But when I added in the second part of the formula it didn't work. It said incorrect argument set
=JOIN(COLLECT(Email47:Email49, Email47:Email49 <> ""), ", ") + "," + JOIN(COLLECT([Palo Alto Additional Emails]47:[Palo Alto Additional Emails]49, [Palo Alto Additional Emails]47:[Palo Alto Additional Emails]49 <> ""), ", ")
Answers
-
@Brittanyy Unfortunately you can't concatenate Contact columns in Smartsheet…. It's a known limitation.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen This worked for when I combined the Email Column
Formula used:
And both columns are Contact
=JOIN(COLLECT(Email47:Email49, Email47:Email49, <>""), ", ")
-
@Brittanyy Yes, you get the emails, but it's not a contact column. If all you need is the text representation of the emails, that works, but if you need them to be in a contact column, that doesn't work.
So your "Palo Alto Combine Contacts" can't be used to send notifications for example. They are just shown as text.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Okay, so this is the formula I have that is not working for me
=JOIN(COLLECT(Email47:Email49, Email47:Email49 <> ""), ", ") + "," + JOIN(COLLECT([Palo Alto Additional Emails]47:[Palo Alto Additional Emails]49, [Palo Alto Additional Emails]47:[Palo Alto Additional Emails]49 <> ""), ", ")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!