title: How to Query Function Google Spreadsheet - Data filtering based on multiple criteria (multiple columns to check at once)
body: <p>I have a Google Spreadsheet that contains five (5) sheets, and we are starting to use them as a basic CRM to manage tasks, projects, deadlines and customers in a very basic fashion.
  We assign tasks to each other in the first sheet "TaskRecords", and then we will populate the other sheets with the information there.
  This the google spreadsheet (with mock data):</p>
  
  <p><a href="https://docs.google.com/spreadsheet/ccc?key=0AkB1z6YLt9N_dDU0VGgyZjN5cGt2UmtRb05FbWRRZ1E#gid=6" rel="nofollow">https://docs.google.com/spreadsheet/ccc?key=0AkB1z6YLt9N_dDU0VGgyZjN5cGt2UmtRb05FbWRRZ1E#gid=6</a></p>
  
  <p>What I would like to achieve is to filter by means of a Query function or so, to use the spreadsheet as a database and filter the following: Taks by Team Member, by Customer, by Deadline, by Project, etc, and displaying the on other sheets.
  I tried with Query formula: <code>=QUERY(TaksRecords!A2:I17; "select A, B, C, D, E, F, H, I where G="AL""; 1)</code>. Where I would like to filter everything that Team Member "AL" has been assigned to do, but I'm missing something.
  I also tried to pull data out to other sheets using <code>Arrayformula</code>, but it only fetchs the cells I tell it to, and does no filtering based on multiple criteria at the same time.
  Furthermore, there will be new rows of data added every day.</p>
  
  <p>Maybe there is some script already written that solves this, I've been testing for several days with different options but couldn't get them to work.</p>
  
  <p>Any hints?</p>
  
  <p>Thanks.</p>