CODEWITHSUNDEEP
google-sheetsgoogle-query-language
Jim55
Jim55

Reputation: 47

google sheets query with dropdowns

I am struggling with my query. It is only showing my header rows. I would like the choice of “staff” or “student” match column C on Responses tab and then the “1.) 11/3/2022 for Boy’s Basketball” match Column E on Response tab. When those two conditions are selected I want to see just the data matching staff and that event. I’m at a loss of how to get this to work.

https://docs.google.com/spreadsheets/d/1icO6CI_xM75jH8PSFSMFrWYZqnBLEIEBNZZI-oDAm_s/edit

Upvotes: 0

Views: 740

Answers (1)

doubleunary
doubleunary

Reputation: 18784

Your formula attempt is:

=query('Form Responses 3'!1:103,"SELECT D,F WHERE C = '"&A1&"' and F = '"&B1&"'")

That fails because your search keys include an apostrophe '.

The easiest solution is probably to express the same through filter(), like this:

=filter( 
  { 'Form Responses 3'!D2:D, 'Form Responses 3'!F2:F }, 
  'Form Responses 3'!C2:C = A1, 
  'Form Responses 3'!F2:F = B1 
)

See your sample spreadsheet.

Upvotes: 1

Related Questions