Filter by Parent Row with Children and Grandchildren

jess_roberts

Hello! I recently created a sheet to track all of our projects (parent row) with some high level milestones (child row). I created a helper column so that I could filter just by the parent row of each project. In the helper column, I used this formula: =IF(COUNT(CHILDREN([Feature Request]@row)) <> 0, [Feature Request]@row, PARENT([Feature Request]@row)).

This worked for a while, but leadership has recently asked to add an additional indent or two, so now I have grandchildren rows. Is there a way that I can keep just the top parent row name in my helper column? I'm not sure what to edit in my formula to make it work.

Any help would be greatly appreciated! Thank you!

Example: I'd like everything in the column named "Project" to just say Project 1 or Project 2 in the screen shot below.

Mike TV

@jess_roberts

Project formula:

=IFERROR(INDEX(ANCESTORS([Feature Request]@row), 1), [Feature Request]@row)

Mike TV

@jess_roberts

Project formula:

=IFERROR(INDEX(ANCESTORS([Feature Request]@row), 1), [Feature Request]@row)

jess_roberts

@Mike TV Thank you so much for the help!!! This is exactly what I needed!