lundi 1 juillet 2019

Google Sheets Query across sheets using checkboxes to limit results

I am making a mini-search engine in Google Sheets. I have information in 3 sheets (6th Grade, 7th Grade, 8th Grade). In the past, I had a Combined sheet that combined the information from each sheet. However, as I add additional sheets for grades 1-5, the amount of information returned will be excessive. I want to allow the user to use checkboxes to identify which grades they want results from.

Here is the workbook. I've added sheets for all the grades by copying the data from 6th, 7th, and 8th. The format of the data will be the same once I get my hands on it.

Here is the formula I've been playing around with:

=iferror(If(D2=True,Query(
             Kindergarten!A:I,"Select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 where Col9>0", 
            ),
      Query(
             {Kindergarten!A:I;'1st'!A:I;'2nd'!A:I},"Select Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8 where Col9>0", 
            ),
      "No Matches, try a different search"))

Aucun commentaire:

Enregistrer un commentaire