title: Google Apps Script setvalue not working
body: <p>I'm using Google Apps Script to create a Google Sheet populated with information from my emails. In column F, I want to create the same formula in all of the rows that will split the delimited values in Column E.</p>
  
  <pre><code>var LastColumn = sheets[1].getLastColumn();
  sheets[1].insertColumnAfter(LastColumn);
  var LastRow = sheets[1].getLastRow();
  for (var a = 1; a &lt; LastRow; a++){
      var cell = sheets[1].getRange('F'+a);
      var place = "=SPLIT(E"+a+",',')";
      cell.setValue(place);
  };
  </code></pre>
  
  <p>While testing, the dynamic range never writes the set value formula. I've changed the formula to a hard-coded value, but it still does not write to the sheet.</p>
  
  <p>Any thoughts?
  Thanks,</p>