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?

  • 1
    filter like =FILTER() or like manual overlay filter?
    – user0
    Commented Jan 22, 2019 at 12:42
  • 1
    Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
    – Blobby
    Commented Jan 24, 2019 at 3:26
  • 1
    for manual overlay its not possible to auto update the range
    – user0
    Commented Jan 24, 2019 at 3:28

1 Answer 1

  • if your formula is: =FILTER(A2:B26, A2:A26 > 5, D2:D26 < 10)

  • then just don't include the last number of closing range: =FILTER(A2:B, A2:A > 5, D2:D < 10)

  • Thanks - if I can't get the manual overlay to auto update, I might look at creating new sheets that reference the first sheet. One for each filtered view I need.
    – Blobby
    Commented Jan 24, 2019 at 3:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.