Freeze Sheet position in Google Sheets -
i have 2 sheets need 1st , 2nd sheets.
- 1st "form responses 1" (linked form)
- 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
Post a Comment