Freeze Sheet position in Google Sheets -


i have 2 sheets need 1st , 2nd sheets.

  1. 1st "form responses 1" (linked form)
  2. 2nd "summary"

everytime form filled creates new sheet, when happens "summary" sheets moves down 3rd place , subsequently lower down more new sheets created.

how can freeze position of 2nd sheet doesnt move 3rd spot , on.

the easiest thing do control new sheet in placed insertsheet(sheetname, sheetindex). sheets 0 indexed, so:

var ss = spreadsheetapp.getactivespreadsheet();  ss.insertsheet('my new sheet', 2); 

would place new sheet after first two. or, use getsheets() , determine last sheet , insert new sheet @ end.


Comments

Popular posts from this blog

php - Permission denied. Laravel linux server -

google bigquery - Delta between query execution time and Java query call to finish -

python - Pandas two dataframes multiplication? -