Recently, someone on this forum put together a formula for me. It works on a sheet pulling responses from a google form. I'm trying to model a new one after that but I'm having trouble. The working formula can be found in the blue box here: https://docs.google.com/spreadsheets/d/1dburRzJAjlFLD6BPifuryopBEzoqnhc--shpq3d7Tik/edit?usp=sharing     If you toggle between the sheet titled BWSU2016 and Form Responses 1, you can see the way formula pulls the info from each submission to multiple rows within BWSU2016.The spreadsheet with which I need help is here: https://docs.google.com/spreadsheets/d/1c6Dq76yDWsFDRPloj8fWtao4MPnK4rGRMIYjIsnZZB0/edit?usp=sharingThe ranges I need to pull are indicated within the formula below. In particular, I am attempting to add an IF statement so that only form responses which indicate Brentwood in column C will be queried.=if(('Form Responses 1'!C2:C=Brentwood),sort(query({'Form Responses 1'!D2:G,'Form Responses 1'!I3:N;'Form Responses 1'!D2:G,'Form Responses 1'!P3:U;'Form Responses 1'!D2:G,'Form Responses 1'!W3:AB;'Form Responses 1'!D2:G,'Form Responses 1'!AD3:AI;'Form Responses 1'!D2:G,'Form Responses 1'!AK3:AP;'Form Responses 1'!D2:G,'Form Responses 1'!AR3:AW},Select * where Col5 <>'' ),D1,if(F1=Z > A,0,1)))
Querying multiple ranges from form responses to new sheet
google spreadsheets