title: Function works in Google Sheets but does not work when using it in Google Script
body: <p>I have this function which works in Google Sheets, but when I put it in Google script it does not work and says I am missing a <code>)</code>.</p>
  
  <pre><code>=ArrayFormula(split(concatenate(filter('Copy of LeaveCache_LVE'!$G$3:$G, 'Copy of LeaveCache_LVE'!$A$3:$A=A3)),"))"))
  </code></pre>
  
  <p>This is what I put in Google script:</p>
  
  <pre><code>cell.setValue('=ArrayFormula(split(concatenate(filter('Copy of LeaveCache_LVE'!$G$3:$G, 'Copy of LeaveCache_LVE'!$A$3:$A=A3)),"))"))');
  </code></pre>