Is there a way to populate a parent cell with multiple data entries from Child rows

ChrisUPC

I am looking for a simple way to have a parent cell list ALL of the different data from Child rows as text.

For instance I have a project listed as a parent row with each part on the project entered as a child row. There is a column with different notes for some child items. Is there a way to make the Parent row populate with comma delineated text so that the notes for all the parts are shown in the parent row?

ChrisUPC

Thanks! That worked great.

Leibel S

@ChrisUPC

The below should work

=JOIN(COLLECT(CHILDREN(), CHILDREN(), @cell <> ""), ", ")

ChrisUPC

Thanks! That worked great.