Join 2 Columns that are not next to Each other.

SherryFox · 02/20/25

I am trying to Join 2 columns of text, but they are next consecutive columns. As this is different from Excel, I am having a hard time with it.

I wish to join text from the # column with the Task Title column, and there will be a " - " to seperate the 2 fields. When finished, it should look like this below. And the formula is on this sheet, so I am not referencing any other sheets.

0001 - Email Update in Smartsheet

Michelle Choate 2 · 02/20/25

Hello @SherryFox!!

Oh start me off with an easy one for the day! I love it!!

= #@row + " - " + [Task Title]@row

Michelle Choate 2 · 02/20/25

Hello @SherryFox!!

Oh start me off with an easy one for the day! I love it!!

= #@row + " - " + [Task Title]@row

SherryFox · 02/20/25

@Michelle Choate 2 ,

a + sign, that is all I needed? Don't I feel stupid! LOL I was looking for Excel-based functions like Concatenate, Textjoin, even tried &, and as expected they all failed! LOL Thanks for your help (even if it was an easy one), I greatly appreciate it!

Michelle Choate 2 · 02/22/25

@SherryFox - Isn't it great how user Friendly Smartsheet is? And always make sure to ask questions on anything you are working on. The community is here to help!

Join 2 Columns that are not next to Each other.

Best Answer

Answers

Help Article Resources

Categories