JOIN with 2 columns that are NOT next to each other, and "force" order

I am (trying to) using the JOIN function. It works but NOT the way I want it to. First, the columns I wanted to join were not next to each other. I am attempting to join 2 columns in a specific order and NOT the column in between. What am I doing wrong? They need to be in this order as the essential piece of data is the name of the Release, and secondary is the Release #.

As you can see in the Unique ID column, the formula is providing the Release # (Releases), then the Source (which should NOT be a part of it), and finally the Release Name. I have listed the way I want it, but cannot get Smartsheet to "obey". My current formula is listed below:

=JOIN([Releaser Name]@row:Releases@row, " | ")

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

JamesB

@Sherry Fox

You do not need to use a join formula. Just write your formula with exactly what you want.

=[Releases]@row+" | "+[Releaser Name]@row

Sherry Fox

@JamesB ,

That did the trick, sometimes I just overcomplicate things! It is perfect, tysvm! And I corrected it to:

=[Releaser Name]@row + " | " + Releases@row

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.