ArrayFormula for the google form

0
votes

So I have a four(4) columns/fields the in my google sheets that link to a google form, these are,

  1. Last_Name
  2. Given_Name
  3. Middle_Name

The only fields that the user will fill up are the first three(3) fields.

on my 4th column, is the Full_Name, now I want to combine the three(3) fields as one(1) using ArrayFormula?

this is my formula, =ARRAYFORMULA(E2&" "&F2&" "&G2), every time I save some records, the formula gone on that specific field.

This is my spreadsheet, that connected to a form

1
google-sheetsgoogle-forms

1 Answers

0
votes

Try

=ARRAYFORMULA(IF(LEN(A2:A), E2:E&" "&F2:F&" "&G2:G,))