Line Break as Delimiter in JOIN(CHILDREN()) Formula

Old Man Coyote

1. I want to aggregate text information from child cells and use a line break as delimiter. How can I do this?

 

2. In Addition it would be nice to have "Primary Column" as prefix before the respective contents.

 

Example

Values for Primary Columns for two rows: Child 1, Child2

Value for relevant text cell of child 1:

- lorem 1

- lorem 2

Value for relevant text cell of child 2:

- lorem 3

- lorem 4

Output of formula (without "Child 1:" and "Child 2:" if 2 as described above is not possible):

Child 1:

- lorem 1

- lorem 2

Child 2:

- lorem 3

- lorem 4

Old Man Coyote

Here's a workaround, at least for #1:

https://community.smartsheet.com/discussion/feature-request-join-carriage-return-separator

Shaine Greenwood

You can also add text strings before the JOIN formula:

 

="Primary Column" + JOIN()

Cesar Maradiaga

I tried this option and didn't see the line break