title: Query and import range only returning header row
body: <p>I'm trying to import a selection of columns if the text in a row is "Week 2." I'm having the issue that the query is only returning the header row. The formula I'm using is this: </p>
  
  <p>=query(importrange("<a href="https://docs.google.com/spreadsheets/d/1Eu5dJ5dOgFsG7jeIB1umoDOamt5r3BzYYoTWA1Rxyh0/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1Eu5dJ5dOgFsG7jeIB1umoDOamt5r3BzYYoTWA1Rxyh0/edit#gid=0</a>", "Sheet1!A:Z"),"select Col5,Col7,Col8 where Col6='Week 2'",1)</p>
  
  <p>I have some test sheets here:</p>
  
  <p>Original where I'm importing info from: <a href="https://docs.google.com/spreadsheets/d/1Eu5dJ5dOgFsG7jeIB1umoDOamt5r3BzYYoTWA1Rxyh0/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1Eu5dJ5dOgFsG7jeIB1umoDOamt5r3BzYYoTWA1Rxyh0/edit#gid=0</a> </p>
  
  <p>Final destination (formula in A2): <a href="https://docs.google.com/spreadsheets/d/19IC36izklxgId5zjtzr9HP71JYTrt_ReHBgxbAwBEpg/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/19IC36izklxgId5zjtzr9HP71JYTrt_ReHBgxbAwBEpg/edit#gid=0</a></p>