Text Join Columns with a row range

Brittanyy

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 <> ""), ", ")

Darren Mullen

@Brittanyy Unfortunately you can't concatenate Contact columns in Smartsheet…. It's a known limitation.

Brittanyy

@Darren Mullen This worked for when I combined the Email Column

Formula used:

And both columns are Contact

=JOIN(COLLECT(Email47:Email49, Email47:Email49, <>""), ", ")

Darren Mullen

@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.

Brittanyy

@Darren Mullen 

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 <> ""), ", ")