I’ve created a simplified table as an example for what I’m trying to do.
I want to create a filter formula for this table that states: If any row with the same type has a checkbox marked, then all rows with that type are filtered out of the table. So for the example table, all rows with “apple” and “orange” will be filtered out of the table.
Does anyone have ideas for how to implement this? I’ve tried a few formulas with no luck so far.