i need help with google sheets
Budget: $15 – $25 USD
i have a google sheet which uses an importrange function and has worked for several years. for some reason, it has suddenly started to fail to copy a couple of rows in the middle of other data and is failing to copy the newest records. i have tried deleting and restoring the importrange formula in the destination sheet with the same result.
thinking that it might be related to the amount of data to be imported, i also tried an arrayformula approach but the result is the same. since neither of these worked, i have tried a script to getValues instead of using importrange but again the result is the same.
it's as if the originating data that is missing from the destination sheet is simply not in the originating sheet even though it's clearly visible. to make matters even more confusing, if i try to print the data in question from a highlighted range in the originating sheet, the missing data which is interspersed with data that is successfully copied shows in the print preview but the data at the end of the sheet which does not get copied is missing from the preview. (see attached).
the interspersed data that is missing from the destination file is for records 2006 and 2009. in addition, i am missing the last 6 records (rows) in the destination file which are clearly included in the originating file. i have included screen shots of the originating data, the destination data and the script i am using. hoping someone can help me with this. i've never seen anything like it.
thinking that it might be related to the amount of data to be imported, i also tried an arrayformula approach but the result is the same. since neither of these worked, i have tried a script to getValues instead of using importrange but again the result is the same.
it's as if the originating data that is missing from the destination sheet is simply not in the originating sheet even though it's clearly visible. to make matters even more confusing, if i try to print the data in question from a highlighted range in the originating sheet, the missing data which is interspersed with data that is successfully copied shows in the print preview but the data at the end of the sheet which does not get copied is missing from the preview. (see attached).
the interspersed data that is missing from the destination file is for records 2006 and 2009. in addition, i am missing the last 6 records (rows) in the destination file which are clearly included in the originating file. i have included screen shots of the originating data, the destination data and the script i am using. hoping someone can help me with this. i've never seen anything like it.