Hi guys, basically I've 3 sheets, in the first sheet I collect data from forms, then I export the results in a 2nd sheet where I perform some cleaning (cos the 1st sheet is really heavy to work with) and then I export those results to a 3rd sheet to do some pivoting and graphs.
The problem is the 3rd sheet. The same importange function that works flawlessy from the 1st to the 2nd, doesn't update and I don't understand why, so to get new data in the 3rd sheet i've to force in some ways (refresh or deleting and redo the formula...I've not found a way that works everytime). Could someone help me to understand why it happens?
I'm using a simple: =importrange("1Pkct3cbagkk-oHoTug8bxB85p5HuonEog4VVKN1LQrg", "4-FINAL!a1:S6000") both between 2nd and 1st and between 3rd and 2nd, only changes are the google id
my 2nd question: I'd like to limit the importrange to the right number of row to make it lighter (those filled). To do it I've made a helper cell in T1 like this: =arrayformula( min( filter(row(D1:D), D1:D = "") ) ) in the 2nd sheet, that give me back the right number of row with data (it works well).
i'm trying then to use this new function to import: =query(importrange("1Pkct3cbagkk-oHoTug8bxB85p5HuonEog4VVKN1LQrg", "4-FINAL!a1:S"), "select * limit " & importrange("1Pkct3cbagkk-oHoTug8bxB85p5HuonEog4VVKN1LQrg", "4-FINAL!T1"), 0)
But it stays forever in "loading"...(even with a refresh nothing change)
Could someone understand why? Ty so much
Bookmarks