TextJoin
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.
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!