Search code examples
if-statementgoogle-sheetsconcatenationgoogle-formstextjoin

Update a google spreadsheet automatically when receive a new entry from google form

Let say we have a google spreadsheet with the following information.

Spreadsheet

The Name and Email address is gotten from people filling out a google form. The Pin is gotten by doing =(A2&" "&B2). Normally I could drag the first value down to fill out the empty cells, but is there a way that, when a new entry is added to the spreadsheet through the google form, the pin for that entry also get filled out?

Solution

  • use in row 1:

    ={"Pin"; INDEX(A2:A&" "&B2:B)}