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
    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!

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!