Sort Range on Spreadsheet with button linked to app script

Question

I have the following code that I'm trying to link to a button to sort a range on the page by the column H (Date). I got the button linked but the code is not working

function sortRange() {
  var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('FBY Team');
 var sheet = ss.getSheets()[0];
 var range = sheet.getRange("A6:M100");

 range.sort({column: 2, ascending: true});

 }

I have added a link to my test spreadsheet. https://docs.google.com/spreadsheets/d/1iWQ40boplJcJmdFg9HNIyOAOrHOjlCRu362LWRdV5y0/edit?usp=sharing

JSmith · Accepted Answer · 2018-10-25 17:09:13Z

2

The problems

'FBY Team' is not one of your sheet.
you usually use ss variable for spreadsheets here you are trying to grab a sheet.
when line 2 is corrected you can delete line 3.
The header starts at row 7 not 6 so range is incorrect

Solution

what I suggest is you change your code to:

function sortRange() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Your Sheet 1');
  var range = sheet.getRange("A7:M100");
  range.sort({column: 2, ascending: true});
 }

this should work now.

answered Oct 25, 2018 at 17:09

JSmith

4,8526 gold badges36 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sort Range on Spreadsheet with button linked to app script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related