0

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?

Improve this question
  • filter like =FILTER() or like manual overlay filter? – user0 Jan 22 '19 at 12:42
  • Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views – Blobby Jan 24 '19 at 3:26
  • for manual overlay its not possible to auto update the range – user0 Jan 24 '19 at 3:28
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)

Improve this answer
  • 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 Jan 24 '19 at 3:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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