title: Copy one row's formula to multiple rows in google apps script
body: <p>I'm using Google Apps Script to copy one row's formula and save it other rows so that the formula changes with the cell values. But for some reason, every time I run my function, I get no error but the formulas don't get copied also.</p>
  <p>Here is my code,</p>
  <pre><code>var ssNew = SpreadsheetApp.openById(ss_id);
  var newSheet = ssNew.getSheetByName(&quot;Sheet1&quot;);
  var formula_source = newSheet.getRange(2, 2, 1, 5);
  var copy_range = newSheet.getRange(3, 2, 10, 5);
  formula_source.copyTo(copy_range);
  </code></pre>
  <p>How can I copy one row's formula to several rows on the same sheet?</p>