There should be a way to toggle option if we want to include child rows inside of a filter. Where we can currently have the parent row option, we should be able to also include child rows.
I am a fan of filters - in the Filters there is a checkbox to show parent rows. A lot times I want filter by the parent row and want to see what is in the child rows that are under the parent row. Which I cannot do. I end up using the Find tool, but this isn't as effective as building Filters as I reuse those all the time. This feature would be helpful - at least for me 🙂
Agreed. I have many parent rows that are essentially an agenda with the child rows being the agenda items. The filter tool isn't able to show me anyof the child rows, when I filter the sheet by keywords. Short of adding a keyword to each child row as well, which would be cumbersome, I don't find a workaround.
This would be very useful. Using a helper column does not work for my scenario as I need a combination of parent and children row entries to complete certain tasks.