I have 4 triggers in Google Apps Script(see the image)
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!
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 }]);
}