i'm relatively new scripting in google sheets , trying write can assigned button sort table column 5 in table. using code below:
function sort() { var ss = spreadsheetapp.getactivespreadsheet(); var sheet = ss.getsheetbyname("items"); var range = sheet.getrange("j2:o13"); range.sort(5); }
however, when assign button , click button, error message "cell reference out of range". may stupid question in advance.
seems trying sort on col 5 (e) not in range. first column in range col 10 (j). if want sort on col o you'll need
range.sort(15)
Comments
Post a Comment