u/MasterSh4k3

My auto-sort script stops working when I freeze a number of row

I'm running the following script to auto-sort my B column:

function sortBColumn() {
  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OFICIAL").sort(2,false)
}function sortBColumn() {
  SpreadsheetApp.getActiveSpreadsheet().getSheetByName("OFICIAL").sort(2,false)
}

It's only 9 rows (B1:B9), so I want that data to stay visible no matter how deep down in rows I go.
But if I freeze rows 1 to 9, the script stops working. It doesn't auto-sort anymore.

How can I keep this working while freezing my selected rows?

reddit.com
u/MasterSh4k3 — 16 days ago