How to make a filter to select only level 3 tasks across multiple sheets?

Carol Lai · 01/07/21

In a row report, how to make a filter to select only level 3 tasks across multiple sheets?

Andrée Starå · 01/07/21

You'll need to have a so-called helper column in the sheets that indicate what level the rows are.

I usually use something like this.

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

Make sense?

Would that work/help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 01/07/21

Hi @Carol Lai