I don't know how to use only the e column filter for the if condition. Here is the code that isn't working.
function myFunction() {
if (SpreadsheetApp.getActive().getActiveSheet().getRange('E1').getFilter() == null) {
var spreadsheet = SpreadsheetApp.getActive();
var criteria = SpreadsheetApp.newFilterCriteria()
.whenCellNotEmpty()
.build();
spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(5, criteria);
spreadsheet.getRange('E1').activate();
spreadsheet.getCurrentCell().offset(2, 0).activate();
}
else {
var spreadsheet = SpreadsheetApp.getActive();
var criteria = SpreadsheetApp.newFilterCriteria()
.build();
spreadsheet.getActiveSheet().getFilter().setColumnFilterCriteria(5, criteria);
spreadsheet.getRange('B1').activate();
spreadsheet.getCurrentCell().offset(2, 0).activate();
}
}
Aucun commentaire:
Enregistrer un commentaire