Formula to bring a list of the children rows into parent row

Tina Chamblee

I need to be able to bring a list of the numbers listed in the Parcel ID column from the children rows into the parent row.

Thanks, Tina

Javed Hassan

Hello!

You can do =JOIN(CHILDREN(), ", ") to have the list populated automatically with a comma-delimiter (change the comma to whatever you want).

Hope this helps!

Tina Chamblee

That helped. I do have one more question: I have other rows that I have a formula is and don't want it to capture that child row. Is there a formula that will work?

I need the list to appear in the one I have circled as well which is in the children row below the parent row.

Javed Hassan

Since those rows are children of the parent formula, you'd end up with a cyclical formula. I'm not sure how you'd be able to pull parent and join children in the same parent/child relationship. I want to say it's not possible, but someone else may have an idea.