I have a generated number based by row (Google Form response). However, doing this limits my ability to filter.I want to create a secondary sheet that updates regularly with the values only (no formulas) then I will gain the function to filter again.Current sheet called Ticket Creation and the New Sheet created/updated called Active Tickets+.function cloneGoogleSheet() {  /* Copy current sheet and replaced it >.< */  var name = labnol;  var ss = SpreadsheetApp.getActiveSpreadsheet();  var sheet = ss.getSheetByName('Ticket Creation');  sheet.getDataRange().copyTo(sheet.getDataRange(), {contentsOnly:true});  /* Before cloning the sheet, delete any previous copy */  var old = ss.getSheetByName(name);  if (old) ss.deleteSheet(old); // or old.setName(new Name);  SpreadsheetApp.flush(); // Utilities.sleep(2000);  sheet.setName('Active Tickets+');  /* Make the new sheet active */  ss.setActiveSheet(sheet);}Currently this will clone to the same sheet (Ticket Creation) and remove the formulas. I'm just starting to play with scripting.
Cloning a sheet without the formula(s)
google spreadsheets;google apps script