title: Trigger IMPORTRANGE using query not working
body: <p>I'm trying to use Query and IMPORTRANGE to get data from another google sheet when a checkbox in the column is TRUE. But I'm just getting an error..</p>
  <p>Found this solution:</p>
  <pre><code>=QUERY(IMPORTRANGE(&quot;G-Sheet URL&quot;, &quot;TAB &amp; range&quot;), &quot;where Col15=TRUE&quot;, 1)
  </code></pre>
  <p>My code:</p>
  <pre><code>=QUERY(IMPORTRANGE(&quot;https://docs.google.com/spreadsheets/d/1ztQla9sOO7xkQdSAMOKHcas81H4jVbYjg9tVi9w1u0o/edit#gid=0&quot;, &quot;Spelbricka!C6:C12&quot;), &quot;where Col6=TRUE&quot;, 1)
  </code></pre>
  <p>It just gives me error.</p>
  <p>Anyone?</p>
  <p>Thanks on behalf / R</p>
  <p><a href="https://i.stack.imgur.com/TlsZY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TlsZY.png" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/64GrC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/64GrC.png" alt="enter image description here" /></a></p>