title: How do I paste format with google sheets script?
body: <p>I'm copying and pasting data from one tab to another within my sheet using below code. The problem is several of the columns are w/l records showing as "9-2" (for ex) and the data is being pasted as values. The w/l records are then incorrectly recalibrated in the 'short date' format.</p>
  
  <pre><code>function copyData() { 
  
    var ss=SpreadsheetApp.getActive();
    var sh=ss.getSheetByName('Standings - live');
    var rg=sh.getRange("A40:P69");
    var vA=rg.getValues();
    var tsh=ss.getSheetByName('Daily Result');
    var trg=tsh.getRange(tsh.getLastRow()+1,1,30,16);
    trg.setValues(vA);
  }
  </code></pre>
  
  <p>The thing is, I need the paste values to clear the logic/syntax out of my cells on the original paste. How do I then add a second step to 'paste format' <em>over</em> the same range to reset the w/l records to the proper format?</p>