谷歌表格中的自动排序功能 [英] Auto Sort Function in Google Sheets

问题描述

我希望此电子表格上的待办事项列表中的项目根据优先级 #(顶部 1，依此类推)自动排序，但我希望它在每次编辑时自动排序.这可以通过排序功能实现吗?提前感谢您的帮助！

I'm looking to get items in my to-do lists on this spreadsheet automatically sorted based on priority # (1 at the top, and so on) but I want it to automatically sort each time it is edited. Is this possible with the sort function? Thanks for your help in advance!

https://docs.google.com/spreadsheets/d/1KHqe8Kvz0e-pbEnoVN6f6vyIyA7VNtuTSQn40q1qGD8/edit?usp=sharing

解决方案

it's not. you will need a script which will do exactly what you request. for example:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");             // SHEET NAME
var range = sheet.getRange("A2:Z");                  // RANGE TO SORT

function onEdit(e)  {
  range.sort([{column: 2, ascending: true}]);        // COLUMN NUMBER TO SORT
}                                                    // TRUE/FALSE FOR ASCENDING/DESCENDING

_________________________________________________________

这篇关于谷歌表格中的自动排序功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！