Have multiple filters saved and enable/disable SOME of them?

Hi Vinicius,

Instead of using filters, sorting the table may do what you want. Numbers sorts the whole table, so rows stay intact.

Sorted by Column D, then C, then B (or whatever suits your purpose)

Recover your original table by sorting by Column A.

Regards,

Ian.

Hi Vinicius,

Badunit's suggestion here is a very workable way to get what you want. Basically I added a column that would return "true" if the conditions I wanted for different filters were met. I applied the different filters with checkboxes. It can lead to IF statements with wild combinations of OR and AND statements. Badunit offloaded his calculations to an independent table so his formulas could be a little less convoluted.

Check back if you have specific questions about implementation.

quinn

That seems so much more difficult and time consuming that just having an option to save filters for using over. At the very least it would be helpful if Apple allowed you to turn on/off the individual filters as opposed to the all or nothing approach they have taken. It's very restrictive IMO... and yes, I have submitted feedback to Apple 😉

Hi jgowrie,

Yes, it is more "difficult and time consuming" than having Apple do it. Good job submitting feedback.

What thrilled me was I could turn various filters on or off within an applescript by changing a value in a checkbox. Great entertainment and the script worked better too.

quinn

jgowrie wrote:

it would be helpful if Apple allowed you to turn on/off the individual filters as opposed to the all or nothing approach they have taken. 😉

Note that for simple individual filters (where you are matching on a value) you can combine multiple filters and turn them on and off individually if you apply them via the dropdown that appears to the right of the down 'arrow' next to the column letter.

For example, starting with this data:

You can filter on, say, 'ABC' in column B:

Giving this:

Then filter on column C for 'XYZ', giving this:

Then remove the filter in column B by selecting the checked 'ABC', which toggles that filter to "off".

Giving this:

And so on...

In this way, with a simple filter applied in each of multiple columns (with some columns perhaps containing a formula that results in TRUE or FALSE, etc), you can achieve sophisticated combinations that can be partially turned on and off.

Not as handy as being able to save named complex filters, but nonetheless flexible and powerful, without requiring complicated formulas.

SG