Automatically sort rows when data is changed

Question

In my Google sheet, I have 2 columns, A and B, which I would like to sort descending by values of Column B. This I know can be done using filter/sort options in sheets. This works as expected but this is a manual step that should be repeated every time data in column B changes.

I would like all rows to be automatically sorted when data in Column B changes. Any ideas to do this?

Example of data in column A and B

Team    Score
Team A  13
Team C  12
Team B  11
Team D  5

An onEdit script will enable you to identify when data in Column B changes, then use sheet.sort(columnPosition, ascending) (doc) will sort your sheet by column. Don't be put-off by the "ascending" reference, you can specify ascending or descending. — Tedinoz
– Tedinoz, Commented Apr 22, 2019 at 12:52

player0 · Accepted Answer · 2019-04-22 13:05:57Z

1

add this script to your sheet:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var range = sheet.getRange("A1:Z");

function onEdit(e)  {
  range.sort([{column: 2, ascending: false}]);
}

Sheet1 = name of the sheet
A1:Z = range to be sorted
column: 2 = column B
ascending: false = descending

answered Apr 22, 2019 at 13:05

player0

131k14 gold badges92 silver badges149 bronze badges

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

3 Comments

Kasper Odgaard Over a year ago

I have an additional question. Lets say i need to sort the rows based on first the score and then the total number of goals. Like this:

Kasper Odgaard Over a year ago

I have an additional question. I need to sort the rows based on first the score (the solution you have) and then the total number of goals - lets say column 3 in this case. So if the score is equal I have to run a second sort that compare the number of goals . Any ideas ?

player0 Over a year ago

you can do it like this: i.sstatic.net/q66Sf.png or adding it one more time for different range separately

Collectives™ on Stack Overflow

Automatically sort rows when data is changed

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related