TextJoin

Sarah Underwood

Hello -

Is there any function(s) within SmartSheet that mimic excel's textjoin function? This seems to be exactly what I need but I can't seem to figure out how to do it within Smartsheet. It merges all of the data needed based on if column n matches any & all items in column A.

Chris Mondeau

Hi @Sarah Underwood ! You might be able to mimic this by using a combination of join() and collect().

Collect() will filter out the rows based on the Branch ID, then wrapping that in the join() will merge the rows together with the delimiter of choice. I put the whole thing in an if(isblank()) on the filter column to leave out any rows without a branch ID grouping. Hope this helps!

rachel_work_

Thank you Chris!!! Years later, I found this thread, and it was very helpful for me :).