Hierarchy Formula Help

NRJW53

Hi Everyone, thank you in advance for your help on this issue.

Currently I have a level column that gives you a number based on the level of the hierarchy the row is assigned to. I am trying to implement a column called "Topic" that lists the Task Name for Level 0 of the hierarchy for all of the children rows.

My formula:

=IF(Level@row = 0, Task@row, IF(Level@row > 0, INDEX(Task:Task, MATCH(0, Level:Level, 0)), ""))

This formula is repeating the Task name for the first level 0 task in the sheet instead of the most recent level 0 parent row for the given child.

Does anyone have any ideas for a solution?

Paul Newcome

Try this:

=IF(Level@row = 0, Task@row, INDEX(ANCESTORS(Task@row), 1))

Paul Newcome

Try this:

=IF(Level@row = 0, Task@row, INDEX(ANCESTORS(Task@row), 1))

NRJW53

@Paul Newcome Thank you so much for the help!

Paul Newcome

Happy to help. 👍️