Google Sheets – Fetch Random String From Array for Each New Form Entry

There's an easy way. For example, for a sum, you can specify it like this:

=SUM(G2:G)

So basically, specify the first cell you want, then the name of the column. That way, you can skip as many rows as you want.

I have expanded the functionality of the script from the linked question accordingly. First it checks whether the sheet with given name already exists. If it doesn't, the sheet is created and the headers of the form responses sheet are copied there. Otherwise, the existing sheet it used. Either way, the newly submitted data is then copied to the sheet.

function copyData(e) {
  var sheetName = e.namedValues['Name'][0];
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName(sheetName);
  if (!sheet) {
    sheet = ss.insertSheet(sheetName);
    var formSheet = e.range.getSheet();
    var headers = formSheet.getRange(1, 1, 1, formSheet.getLastColumn());
    headers.copyTo(sheet.getRange(1, 1));
  }
  sheet.appendRow(e.values);
}

The function must be equipped with a trigger using "Resources -> current project's triggers" in the Script Editor menu: the trigger options are "from spreadsheet", "on form submit".