When I create a filter in Google sheets, I want the range to automatically expand as I add/populate new rows. Sometimes, this works fine:
When I have a column using “Checkbox” data validation (required for my project), the range never auto-expands:
My goal is to auto-expand the range whenever a new row is populated (also acceptable: auto-expand the range when a new row is first added) even when checkbox data validation is present.
I suspect I can accomplish this through a simple script, but I want to better understand the expected behavior. What is the logic for when the filter range auto-expands and when it doesn’t? I’ve searched the web but haven’t found a clear answer.