Data one one line

Jett

Hi,

I have the data across multiple columns how do I have it all on the main parent level. I would like to build a report that includes it all but having issues since the data is in a different row. Then I need to be a formula so it auto calculates going forward since the data will be dynamic

Paul Newcome

On the parent row, you would use:

=INDEX(COLLECT(CHILDREN(), CHILDREN(), @cell <> ""), 1)

This can be applied to any column on any parent row.

Jett

@Paul Newcome This formula is not working

Paul Newcome

Can you provide more details? Is it not pulling in the correct data? Is it throwing an error? Can you provide a screenshot of the formula open in the sheet as if you are about to edit it?

Jett

Hi @Paul Newcome

There many parent levels on this sheet I would like the formula pull out the data for all and when new ones enter the sheet.

Paul Newcome

What would be the expected outcome?

Jett

Hi @Paul Newcome

I have one in now that I entered manually and dragged down but this will not work when new lines are added to the sheet I would like in this example 2014 | Genie | S- 40 | 22,000 There are currently 32 parent levels on this sheet but there will be many more added her soon. So I would like this to display once a new line is added without having to drag my other formula down each time.