Skip to content

Instantly share code, notes, and snippets.

@benjiwheeler
Created May 27, 2015 14:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save benjiwheeler/afa6559756bbb1bd4693 to your computer and use it in GitHub Desktop.
Save benjiwheeler/afa6559756bbb1bd4693 to your computer and use it in GitHub Desktop.
Autosort button script for Google Sheets
function resort(tableRange, columnToSortBy){
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getRange(tableRange);
range.sort( { column : columnToSortBy, ascending: false } );
}
// just a wrapper; timestamp is just anti-cacheing trick
function myGetRangeByName(n, timestamp) {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
return sheet.getRangeByName(n).getA1Notation();
}
function resort_projects(){
// Date() just introduces a cacheing-resistent parameter, to force sheets to recheck result of that function
var tableRange = myGetRangeByName("projects", Date());
var columnToSortBy = 5;
resort(tableRange, columnToSortBy)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment