I am trying to sort specific columns on a google sheet but exluding a few different tabs. I use google scripts a decent amount in my job but most of the scripts I get from Stack and then edit them because I am not a developer/engineer, I'm in a non-tech role but I know a slight amount about coding.

Can someone that knows coding tell me what I am doing wrong?

I know there is a more efficient way to do the naming conventions of the columns and the ascending and I will change that later but wanted to see if anyone knows why I am getting this error? Thanks!

I found this code from a Stack post that I changed that I feel like should work but I keep getting this error on my trigger which is "onEdit":

"Error: The coordinates of the range are outside the dimensions of the sheet."

 function sortEverySheetTest() {
  var excludeSheetNames = ["Sheet 1","Sheet 2","Sheet 3", "Sheet 4", "Sheet 5", "Sheet 6", "Sheet 7", "Sheet 8"]; // <--- Added

  var sortFirst = 5;
  var sortFirstAsc = true;
  var sortSecond = 6;
  var sortSecondAsc = true;
   var sortThird = 7;
  var sortThirdAsc = true;
  var headerRows = 2;
  var activeSheet = SpreadsheetApp.getActiveSheet();
  var sheetName = activeSheet.getSheetName();

  if (excludeSheetNames.includes(sheetName)) return; // <--- Added

  var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
  var range = sheet.getRange(headerRows 1, 1, sheet.getMaxRows()-headerRows, sheet.getLastColumn());
  range.sort([{ column: sortFirst, ascending: sortFirstAsc }, { column: sortSecond, ascending: sortSecondAsc }, { column: sortThird, ascending: sortThirdAsc }]);
}

CodePudding user response：

Try this:

function onMyEdit(e) {
  e.source.toast("Entry");
  const excl = ["Sheet 1","Sheet 2","Sheet 3", "Sheet 4", "Sheet 5", "Sheet 6", "Sheet 7", "Sheet 8"]; 
  const sh = e.range.getSheet();
  const shts = e.source.getSheets().filter(sh => !~excl.indexOf(sh.getName())).map(sh => sh.getName());
  const idx = shts.indexOf(sh.getName());
  if(~idx) {
    e.source.toast("Gate1");
    let rg = sh.getRange(3,1,sh.getLastRow() - 2,sh.getLastColumn());
    rg.sort([{column:5,ascending:true},{column:6,ascending:true},{column:7,ascending:true}]);
  }
}

Here's the markdown table for my sheet data after sorting: