Skip to content

Instantly share code, notes, and snippets.

@adamcbrewer

adamcbrewer/sortBy.onEdit.gs

Created February 1, 2014 14:43
Download ZIP

Revisions

  1. adamcbrewer created this gist Feb 1, 2014.
    15 changes: 15 additions & 0 deletions sortBy.onEdit.gs
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,15 @@
    /**
    * Automatically sorts the 1st column (not the header row) Ascending.
    */
    function onEdit(event){
    var sheet = event.source.getActiveSheet();
    var editedCell = sheet.getActiveCell();

    var columnToSortBy = 1;
    var tableRange = "A4:Z99"; // What to sort.

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