title: issue with getLastRow in google sheet
body: <p>I am using a code to transfer copied data from one sheet to another in google sheets. Unfortunately, I'm having issues since the other sheet where I paste the other values has a formula on some column. instead of being set on the next possible available row, "A2" it goes down to "A152"</p>
  
  <p>Here's the code that I am currently using:</p>
  
  <pre><code>function submit() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var formSS = ss.getSheetByName("Form");
  var mastersheet = ss.getSheetByName("Dump");
  
  var values = [[formSS.getRange("F10").getValue(),
  formSS.getRange("C7"),getValue(),
  formSS.getRange("C8"),getValue(),]];
  
  mastersheet.getRange(matersheet.getLastRow()+1,1,1,3).setValues(values)
  }
  </code></pre>
  
  <p>your help will be appreciated!</p>