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.
Help Article Resources
Check out the Formula Handbook template!