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

Find more posts tagged with

Formulas

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.