I have a Google Sheet document with many rows in it. I have several filters set up to view different collections of rows.
The problem is, this sheet has new rows automatically added to it several times a day from automated external sources.
So, whenever someone goes to view one of the filters, it is no longer filtering all rows, as the range for the filter does not include the rows added to the sheet since the last set.
Is there a way to have this range automatically update the end of the range to be the "last" row of the sheet?