Skip to content

Instantly share code, notes, and snippets.

@lolandese

lolandese/GS_sort_in_menu.js

Last active May 24, 2018 13:36
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save lolandese/af2edea92b829090ac24 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save lolandese/af2edea92b829090ac24 to your computer and use it in GitHub Desktop.
Download ZIP
Google Sheets script to sort on two columns as a menu option.
Raw
GS_sort_in_menu.js
// Merge related issues: Try selecting all cells, then click Format > Merge cells > Unmerge
function onOpen(e) {
var menu = SpreadsheetApp.getUi().createMenu('Sort');
if (e && e.authMode == ScriptApp.AuthMode.NONE) {
// Add a normal menu item (works in all authorization modes).
menu.addItem('Sort Sheet', 'sort');
} else {
// Add a menu item based on properties (doesn't work in AuthMode.NONE).
var properties = PropertiesService.getDocumentProperties();
var workflowStarted = properties.getProperty('workflowStarted');
if (workflowStarted) {
menu.addItem('Sort Sheet', 'sort');
} else {
menu.addItem('Sort Sheet', 'sort');
}
menu.addToUi();
}
}
function sort() {
/** Variables for customization:
Each column to sort takes two variables:
1) the column index (i.e. column A has a colum index of 1
2) Sort Asecnding -- default is to sort ascending. Set to false to sort descending
**/
//Variable for column to sort first
var sortFirst = 8; //index of column to be sorted by; 1 = column A, 2 = column B, etc.
var sortFirstAsc = true; //Set to false to sort descending
//Variables for column to sort second
var sortSecond = 3;
var sortSecondAsc = false;
//Number of header rows
var headerRows = 1;
/** End Variables for customization**/
/** Begin sorting function **/
var activeSheet = SpreadsheetApp.getActiveSheet();
var sheetName = activeSheet.getSheetName(); //name of sheet to be sorted
var sheet = SpreadsheetApp.getActive().getSheetByName(sheetName);
var range = sheet.getRange(headerRows+1, 1, sheet.getMaxRows()-headerRows, sheet.getLastColumn());
range.sort([{column: sortFirst, ascending: sortFirstAsc}, {column: sortSecond, ascending: sortSecondAsc}]);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment