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

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:

image.png

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!!

Tags:

Answers

  • Melissa Yamada
    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.

    Melissa Yamada
    melissa@insightfulsheets.com
    Data made simple, spreadsheets reimagined

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!