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

Sherry Fox

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

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