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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!