title: Get Sheet By Name not working - only accepts one sheet
body: <p>I have a spreadsheet connected to a google form, however I have another tab "sheet3" which uses array formula from "Form Responses 1". </p>
  
  <p>The script I am using which sends all questions and answers to other emails does not take the info from "sheet3", only from "Form responses 1".</p>
  
  <p>I have tried so many different things and nothing. Here's my script:</p>
  
  <pre><code>function sendFormAnswers(data) { 
  Logger.log("sendEmail");
  
  
  var values = SpreadsheetApp.getActiveSheet(); 
  var row = values.getLastRow(); 
  
  
  var s = SpreadsheetApp.getActive().getSheetByName("sheet3").activate();
  var headers = s.getRange(1,2,1,s.getLastColumn()-1).getValues()[0];
  
  var values = s.getRange(s.getLastRow(),1,s.getLastRow(),s.getLastColumn()-1).getValues()[0];
  var row = values[0];
  
  var timestap = values[0];
  var ABS = values[1];
  var OPS = values[2];
  </code></pre>
  
  <p>many thanks</p>