title: Trying to apply CONCATENATE via ARRAYFORMULA on Google Sheet
body: <p>I have the following formula that I would like to apply to a column via ARRAYFORMULA. Due to the fact that new rows are added via GOOGLE FORMS I cannot COPY + PASTE because each new FORM entry deletes all columns to the right.</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>=IF(ISBLANK(A3),"", CONCATENATE(E3," : [",G3,"] : ",H3," ( ",text(C3,"HH:MM")," - ",text(D3,"HH:MM")," )"))</code></pre>
  </div>
  </div>
  </p>