Can you auto update the range for a filter in Google Sheets?
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?
google-sheets formulas filter
edited Jan 22 at 15:08
serenesat
8,857102242
asked Jan 21 at 7:54
BlobbyBlobby
1
migrated from superuser.com Jan 22 at 12:22
This question came from our site for computer enthusiasts and power users.
add a comment |
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?
google-sheets formulas filter
edited Jan 22 at 15:08
serenesat
8,857102242
asked Jan 21 at 7:54
BlobbyBlobby
1
migrated from superuser.com Jan 22 at 12:22
This question came from our site for computer enthusiasts and power users.
filter like=FILTER()or like manual overlay filter?
– MARK MY ANSWER
Jan 22 at 12:42
Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
– Blobby
Jan 24 at 3:26
for manual overlay its not possible to auto update the range
– MARK MY ANSWER
Jan 24 at 3:28
add a comment |
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?
google-sheets formulas filter
edited Jan 22 at 15:08
serenesat
8,857102242
asked Jan 21 at 7:54
BlobbyBlobby
1
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?
google-sheets formulas filter
google-sheets formulas filter
edited Jan 22 at 15:08
serenesat
8,857102242
asked Jan 21 at 7:54
BlobbyBlobby
1
edited Jan 22 at 15:08
serenesat
8,857102242
asked Jan 21 at 7:54
BlobbyBlobby
1
edited Jan 22 at 15:08
serenesat
8,857102242
edited Jan 22 at 15:08
serenesat
8,857102242
edited Jan 22 at 15:08
serenesat
8,857102242
8,857102242
asked Jan 21 at 7:54
BlobbyBlobby
1
asked Jan 21 at 7:54
BlobbyBlobby
1
asked Jan 21 at 7:54
BlobbyBlobby
1
1
migrated from superuser.com Jan 22 at 12:22
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Jan 22 at 12:22
This question came from our site for computer enthusiasts and power users.
filter like=FILTER()or like manual overlay filter?
– MARK MY ANSWER
Jan 22 at 12:42
Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
– Blobby
Jan 24 at 3:26
for manual overlay its not possible to auto update the range
– MARK MY ANSWER
Jan 24 at 3:28
add a comment |
filter like=FILTER()or like manual overlay filter?
– MARK MY ANSWER
Jan 22 at 12:42
Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
– Blobby
Jan 24 at 3:26
for manual overlay its not possible to auto update the range
– MARK MY ANSWER
Jan 24 at 3:28
filter like
=FILTER() or like manual overlay filter?– MARK MY ANSWER
Jan 22 at 12:42
filter like
=FILTER() or like manual overlay filter?– MARK MY ANSWER
Jan 22 at 12:42
Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
– Blobby
Jan 24 at 3:26
Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
– Blobby
Jan 24 at 3:26
for manual overlay its not possible to auto update the range
– MARK MY ANSWER
Jan 24 at 3:28
for manual overlay its not possible to auto update the range
– MARK MY ANSWER
Jan 24 at 3:28
add a comment |
1 Answer
1
active
oldest
votes
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)
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
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 at 3:27
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "34"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f124433%2fcan-you-auto-update-the-range-for-a-filter-in-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
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)
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
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 at 3:27
add a comment |
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)
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
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 at 3:27
add a comment |
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)
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
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)
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
answered Jan 22 at 12:47
MARK MY ANSWERMARK MY ANSWER
8,16861431
8,16861431
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 at 3:27
add a comment |
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 at 3:27
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 at 3:27
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 at 3:27
add a comment |
Thanks for contributing an answer to Web Applications Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fwebapps.stackexchange.com%2fquestions%2f124433%2fcan-you-auto-update-the-range-for-a-filter-in-google-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
filter like
=FILTER()or like manual overlay filter?– MARK MY ANSWER
Jan 22 at 12:42
Ah - asking the real question. I mean a manual overlay - using the menu: Data - Filter Views
– Blobby
Jan 24 at 3:26
for manual overlay its not possible to auto update the range
– MARK MY ANSWER
Jan 24 at 3:28