Filter to show all parent rows and tasks under a single parent row

Marissa.Russell

I have a sheet that is broken up by 4 workstreams. I would like to be able to apply a filter that only shows me anything under 1 of those workstreams. An example of my hierarchy is below. I want to be able to filter out anything in workstream 1, 3 & 4 so I am left with all parent rows and tasks under workstream 2:

Unfortunately, I can only find answers that will allow me to filter for 1 level of parent rows. I also would like to mention there are about 30 different people adding tasks into this plan and is done so on a daily basis- so the idea of using a checkbox to identify the rows I want to filter would require me to go in regularly and manually check any additional rows that have been added by other resources.

Any help is appreciated. Thank you!!

Melissa Yamada

Hi @Marissa.Russell ,

You could create a column that returns the level 1 ancestor for each row. Something like

=INDEX ( ANCESTORS ( Task name@row, 1))

Then create a filter off of that column.