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

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?

CodePudding user response：

use in row 1:

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