Transaction Sheet Filters Don't "Expand" After Fill

Spreadsheets Google Sheets
5

I’m not sure why the check box throws things off :man_shrugging:

One option would be to automate the data filter reset using a time-driven macro that runs after auto-fill. I do this actually before auto-fill, just to avoid any confusion that can happen when forgetting to clear filtering (and not because of your check box issue). Macros can also be run using a hot-key.

For reference, here’s the macros.gs code.

function resetDataFilter() {
  var spreadsheet = SpreadsheetApp.getActive();
  var sheet = spreadsheet.getSheetByName('Transactions');
  spreadsheet.setActiveSheet(sheet);
  var range = sheet.getDataRange();
  var filter = sheet.getFilter();
  if (filter) {
    filter.remove();
    range.createFilter();
  }
  sheet.getRange('A2').activate();
};

I will say that I’ve seen The Sheet Sanitizer hang while writing the Transactions sheet that contains a cell with a TRUE value (i.e. checked check box). Maybe it’s specific to that tool, but something to keep in mind.