title: insert formula in newly created rows
body: <p>Hi everyone was wondering how do i insert a formula into the newly created row
  this script inserts 10 new row and i would like to instert a formula in the 10 new created row in the column E</p>
  
  <pre><code>var ss = SpreadsheetApp.getActive();
  var target = ss.getSheetByName('Data Entry');
  target.insertRowsAfter(target.getMaxRows(), 10)
  </code></pre>
  
  <p>what would i need to insert this formula in those newly created rows</p>
  
  <pre><code>=If(len(D3:D),vlookup(D3:D,'Configuration List'!A2:B,2,0),"")
  </code></pre>