How can I label rows based on their level 0 text?

Ben B.

I'm looking for a column formula that will apply the text from level 0 to all of its children, grandchildren, etc. My sheet has multiple level 0 rows.

Paul Newcome

You would use something like this:

=INDEX(ANCESTORS([Primary Column]@row), 1)

Paul Newcome

=IFFERROR(INDEX(ANCESTORS([Primary Column]@row), 1), [Primary Column]@row)

Paul Newcome

You would use something like this:

=INDEX(ANCESTORS([Primary Column]@row), 1)

Ben B.

That worked great! The only snag now is that it returns an #INVALID VALUE error for the Level 0 rows. This is a minor problem that I can work around, but it'd be great if it had the same label.

Paul Newcome

=IFFERROR(INDEX(ANCESTORS([Primary Column]@row), 1), [Primary Column]@row)

Ben B.

Thanks! That took care of the error. :)

Paul Newcome

Happy to help. 👍️