Row Delimiter in a formula?

keysaab

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?

Thanks!

heyjay

You can use CHAR(10) for line break, and make sure that the WRAP TEXT is enable.

=JOIN(DESCENDANTS([Program]@row), CHAR(10))