Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function Clear_Filter() {
- var spreadsheet = SpreadsheetApp.getActive();
- spreadsheet.getRange('A5').activate();
- spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(1);
- spreadsheet.getRange('B5').activate();
- spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(2);
- spreadsheet.getRange('C5').activate();
- spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(3);
- spreadsheet.getRange('G5').activate();
- spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(7);
- spreadsheet.getRange('J5').activate();
- spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(10);
- spreadsheet.getRange('M5').activate();
- spreadsheet.getActiveSheet().getFilter().removeColumnFilterCriteria(13);
- };
Add Comment
Please, Sign In to add comment