title: How to Query Function in Google Sheets (data filtering to pull data to other sheets)
body: <p>I found this <a href="https://stackoverflow.com/questions/18677202/how-to-query-function-google-spreadsheet-data-filtering-based-on-multiple-crit/18677979#18677979?newreg=de8700e52df4429c86681e3a675174c3">How to Query Function Google Spreadsheet - Data filtering based on multiple criteria (multiple columns to check at once)</a> to be super helpful and thanks to @mogsdad for their reply. I'm hoping someone can help me with something very similar that I just cannot get to work. I've tried changing the query string in every way that I know how but cannot get it to pull data into the sheets properly.</p>
  
  <p>When I have students fill in a form I want the data from their submissions to be pulled to other sheets based on their period. The sheet the data originates from is called "Responses" and there are 4 more sheets on which I hope the data will end up.</p>
  
  <p>Link to document: <a href="https://docs.google.com/spreadsheet/ccc?key=0Ai9OxTXw1vPUdFFfMkJCM2REVU5xYzRxVFhHd2p1b0E&amp;usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheet/ccc?key=0Ai9OxTXw1vPUdFFfMkJCM2REVU5xYzRxVFhHd2p1b0E&amp;usp=sharing</a></p>
  
  <p>I tried this query formula (and it sort of worked for 1st period but not for the other ones):</p>
  
  <p>=QUERY(Responses!A2:I17; "select A, B, C, D, E, F where D='1st Period'"; 1)</p>
  
  <p>Thank you in advance for helping a very stressed-out teacher!</p>