Skip to content

Latest commit

 

History

History
20 lines (16 loc) · 651 Bytes

sorting-by-date-bysheetname.md

File metadata and controls

20 lines (16 loc) · 651 Bytes

Google Appscript Sorting rows by date column

  • Yes/No column move row to Approval or Reject sheet and sent out email notifications
//Sorting by date in column 1
function onOpen(open) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("APPROVED");
  var editedCell = sheet.getActiveCell();
 
  var columnToSortBy = 1;
  var tableRange = "A2:AB500"; //500 shouldn't be higher than actual rows you have in spreadsheet, you will get error.

    if(editedCell.getColumn() == columnToSortBy){
      var range = sheet.getRange(tableRange);
      range.sort( { column : columnToSortBy, ascending: false } );
  }
}