title: Clear values, not formulas
body: <p>I have a script to copy values from one sheet to another that works perfectly except I only want to clear the values in the source sheet, and leave the formula in place in cells E3, I3 and J3</p>
  
  <pre><code>function addLeavers()
   {
    var ss = SpreadsheetApp.getActiveSpreadsheet();
    var source = ss.getRange("Add Leaver!A3:AM3");
    var destSheet = ss.getSheetByName("Leavers");
    destSheet.appendRow(source.getValues()[0]);
    source.clear();
  }
  </code></pre>