Row Delimiter in a formula?


Hi all,

I have a sheet that contains hierarchy, I needed to make a dynamic view and maintain the hierarchy, which I partially achieved with formula columns. Long story short, I have a parent cell (program) and children cells (parts). In dynamic view I want to have 'program' in the main view, which I achieved and 'parts' in the detail view, which I managed to do with the formula column below.

=JOIN(DESCENDANTS([Program]@row), " || ")

However, it shows as a blob of text and the delimiter is " || ". It is hard to read for users. I would like to have it delimited by row but cannot figure out for the life of me how to put it in the formula. Is it even possible? Or is there a workaround?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!