get parameter error when try to sort google sheets by 2 columns

Question

I tried to do simple sort by 2 columns, there is many examples. but I got parameter error. and cant understand why here is my code:

function myFunction1() {
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet = spreadsheet.getActiveSheet();
  var dateColumn = 1;
  var houerColumn = 3;

  sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate();
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  sheet.sort([{ column: 1, ascending: true }, { column: 3, ascending: true}]);
};

and the error I got is: Exception: Cannot convert '[object Object],[object Object]' to int. on row number 10 (the sort row). what do I do wrong?

Can you give us an extract of your data, or look closely what values are in A10 and C10. Pls, precise also which sheet do you want to sort : you first choose the active sheet, then the first sheet (index 0) = may be the line var sheet = ss.getSheets()[0] is not necessary. — Mike Steelson
– Mike Steelson, Commented Jul 25, 2021 at 11:21
There are no object parameters in sheet sort: developers.google.com/apps-script/reference/spreadsheet/… There is just an integer and a boolean — Cooper
– Cooper, Commented Jul 25, 2021 at 16:20

MattKing · Accepted Answer · 2021-07-25 12:16:58Z

5

It seems you are over-complicating things. The way you're trying to sort is usually done on ranges, not sheets. This code should suffice:

function myFunction1(){
  SpreadsheetApp.getActiveSheet().getDataRange().sort([{ column: 1, ascending: true }, { column: 3, ascending: true}]);
}

answered Jul 25, 2021 at 12:16

MattKing

7,80310 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

get parameter error when try to sort google sheets by 2 columns

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