title: Google Script GetRange with Filter based on values in a column AND select only certain columns
body: <p>I have a dataset of 35 columns and 300 rows. I want to get the range that contains rows only for certain values in column 30 (names). The name for which to filter the data is based on the report file cell B6 in the report sheet that is active. So far I tried this:</p>
  <pre><code>var report = SpreadsheetApp.getActiveSpreadsheet();
  var tsheet = report.getSheetByName(&quot;Transactions&quot;);
  var areport = SpreadsheetApp.getActiveSheet();
  var agent = areport.getRange('B6').getValues();
  
  var criteria = SpreadsheetApp.newFilterCriteria().whenTextEqualTo(agent).build();
  var trange = tsheet.getRange().createFilter().setColumnFilterCriteria(30, criteria); // ERROR
  var tdata = trange.getValues();
  </code></pre>
  <p>I receive an error Exception: The parameters () don't match the method signature for SpreadsheetApp.Sheet.getRange.</p>
  <p>The second part, I only want to get several columns, 5,6,7, 13, 15. I can't create another filter with the Spreadsheet app, so is the only way to make an array and filter out the needed data from there? I'm just trying to think ahead and reduce the amount of calculations.</p>