How to apply table filter view to ONLY parent rows, but have child rows follow it?

JPJPJP

I have a table with parent and child rows. Whenever I create a table filter view, it applies it to ALL rows and breaks the hierarchy. I want to create a view that simply is applied to the parent rows only, and ignores the child rows but carries them with the parent.

I tried creating a helper "Parent " column, but then it no longer shows the child rows.
For example, I want a filter view that does this: Only show rows where the Parent's Invoiced column is not checked. If the Invoiced column checked, then hide that parent row along with all it's child rows.

e.g. Table Format:

Parent Project 1
—- Ticket 1
—- Ticket 2
Parent Project 2
—- Ticket 3
—- etc.

Georgie

Hi @JPJPJP,

You could do this by creating a helper checkbox column with a formula that checks the box for child rows when their parent row is checked in the Invoiced column.

I named my helper column “Invoiced children” and used the following formula:

• =IF(PARENT(Invoiced@row ) = 1, 1, 0)

You can see this working in my test sheet below:

I then created a filter that shows rows where the Invoiced column is unchecked AND the Invoiced children column is unchecked, as seen below:

You can see that when the filter is applied, only the rows where both columns are unchecked are displayed:

That is, parents are shown along with their children if both columns are unchecked, and any parent rows that are checked are hidden, along with their children.

Does that work for you?

Georgie