Search code examples
google-apps-scriptgoogle-sheetsgoogle-sheets-formula

Google Apps Script Tiggers events not working


I have 4 triggers in Google Apps Script(see the image)

enter image description here

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("DATA2");             
var range = sheet.getRange("A2:Z");                  
 
function onOpen(e)  {
 range.sort([{column: 1, ascending: false}]);        
}

The problem I have is with the triggers: "runsies" and "onOpen" that don't start at Spreedsheet open. The two triggers run perfectly manually.

I update with the what I use in Apps Script

Need some help please.

Thanks!


Solution

  • function onOpen(e) {
      var ss = SpreadsheetApp.getActive();
      var sheet = ss.getSheetByName("DATA2");
      var range = sheet.getRange("A2:Z" + sheet.getLastRow());
      range.sort([{ column: 1, ascending: false }]);
    }