Question: I am trying to make a simple grocery shopping list, where items can be checked and added to a filtered list. There will be different categories in different tabs/sheets (Produce, Dairy, Snacks, Household and Other). I currently have this filter in cell A1 of the SHOPPING LIST sheet:

`=FILTER(Produce!B2:E,Produce!A2:A=TRUE)`

Is it possible to have another filter run automatically after this, once the above filter runs and the number of rows is known? So that all filters run vertically to create the full shopping list:

`=FILTER(Diary!B2:E,Dairy!A2:A=TRUE)`

And then the next, etc.

`=FILTER(Snacks!B2:E,Snacks!A2:A=TRUE)`  

`=FILTER(Household!B2:E,Household!A2:A=TRUE)`  

`=FILTER(Other!B2:E,Other!A2:A=TRUE)`

Answer: 
**UPDATE** *(Following [OP's comment](https://stackoverflow.com/questions/72690439/can-i-automatically-run-another-goolge-sheets-filter-after-below-a-filter/72690537?noredirect=1#comment128479443_72690537))*

You can either use a [QUERY](https://support.google.com/docs/answer/3093343) instead

```
=QUERY({{Produce!A2:A; Diary!A2:A; Snacks!A2:A; Household!A2:A; Other!A2:A},
        {Produce!B2:E; Diary!B2:E; Snacks!B2:E; Household!B2:E; Other!B2:E}}, 
                              "select Col2, Col3, Col4, Col5 where Col1=TRUE",0)

```

OR stick with the `FILTER` function

```
=IFERROR(
      FILTER({Produce!B2:E; Diary!B2:E; Snacks!B2:E; Household!B2:E; Other!B2:E}, 
             {Produce!A2:A; Diary!A2:A; Snacks!A2:A; Household!A2:A; Other!A2:A}=TRUE),
                        {"","","",""})

```

---

You could probably use something like:

```
={FILTER(Diary!B2:E,Dairy!A2:A=TRUE);
  FILTER(Snacks!B2:E,Snacks!A2:A=TRUE);
  FILTER(Household!B2:E,Household!A2:A=TRUE);
  FILTER(Other!B2:E,Other!A2:A=TRUE)}

```
or try:

```
=FILTER({Produce!B2:E; Diary!B2:E; Snacks!B2:E; Household!B2:E; Other!B2:E}; 
        {Produce!A2:A; Diary!A2:A; Snacks!A2:A; Household!A2:A; Other!A2:A}=TRUE)

```