I have a series of filter views that filter my Google sheet based on the values in column B.
I have 200 rows in my sheet, so the range for each filter view is A1:C200.
Often, new rows get added to my sheet (in my case, via Zapier, but inserting new rows at the bottom manually has the same effect). Each time this happens, I need to manually update the range of each filter view to be A1:C201, etc.
I have tried to set the range of the filter views to be A1:C (thinking this would cover entire columns forever), but my formula gets corrected to A1:C200.
Is there a way to get filter views to apply to entire columns, so that new rows added to a sheet are also captured by the filter view?