Why doesn't my sorting function work? (Google sheets)

Question

I have defined the following function in the scripteditor

function SORTBYLEN(input) {
    return Array.isArray(input) ?
        input.sort((a,b) => a.length - b.length): input
}

I would expect to be able to give it a range of strings and it would return the range sorted by string length, yet when I try to use it, nothing changes.

Tanaike · Accepted Answer · 2021-03-31 13:39:55Z

2

I thought that the reason of your issue is due to that input is 2 dimensional array. By this, the length of each element is 1. So the array of input is not sorted. In order to avoid this issue, how about the following modification?

Modified script:

return Array.isArray(input) ? input.sort((a, b) => a[0].length - b[0].length) : input;

or

return Array.isArray(input) ? input.flat().sort((a, b) => a.length - b.length) : input;

Reference:

Custom Functions in Google Sheets

answered Mar 31, 2021 at 13:39

Tanaike

203k12 gold badges126 silver badges222 bronze badges

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

Collectives™ on Stack Overflow

Why doesn't my sorting function work? (Google sheets)

1 Answer 1

Modified script:

Reference:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Modified script:

Reference:

Comments

Your Answer

Sign up or log in

Post as a guest

Related