对不同的列使用不同的过滤器Google Script

function applyFilters() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var range = sheet.getDataRange();
  var values = range.getValues();

  values.forEach(function(row) {
    var columnIndex = row.getColumn();
    var filteredValues = [];

    if (columnIndex === 1) {
      // Apply filter for column 1
      filteredValues = row.filter(function(value) {
        // Filter condition for column 1
        return value > 10;
      });
    } else if (columnIndex === 2) {
      // Apply filter for column 2
      filteredValues = row.filter(function(value) {
        // Filter condition for column 2
        return value.startsWith('A');
      });
    } else {
      // Apply default filter for other columns
      filteredValues = row.filter(function(value) {
        // Default filter condition
        return value !== '';
      });
    }

    // Write filtered values back to the sheet
    sheet.getRange(row.getRow(), 1, 1, filteredValues.length).setValues([filteredValues]);
  });
}