I am not sure exactly when this started, but as of this morning, my ARRAYFORMULAs in Google Sheets are no longer working. Only the row that contains the actual formula (first row) will sync. When I remove the ARRAYFORMULA and drag the formula down, it works properly again. This is fine as a workaro…

It’s a VLOOKUP that pulls in information from another Google Sheet. This formula - wrapped in an ARRAYFORMULA: =VLOOKUP(B2:B,IMPORTRANGE(“ https://docs.google.com/spreadsheets/d/xyz/edit#gid=0","Placements!B:G ”),2,FALSE)

Wouldn’t it be better to use Relation/Lookup or Query/SingleValue in Glide? It would be a whole lot more responsive (instant) and you wouldn’t have the delay of waiting for the result from the VLOOKUP to sync back to Glide and back to your device. [image] litter_in_bin_sign …

It absolutely would but the data I need is in an entirely separate Google sheet. I can’t really combine them feasibly into a single sheet, and I can’t use multiple Sheets as data sources in the same Glide app. Plus, the strange part is, this was working completely fine for months, AFAIK until this…

OK. Just for clarification, is it true that the ArrayFormula appears to be working when you view it in the google sheet, and the issue is only that it does not sync all of the data in that column to Glide? In my experience I’ve had issues in the past where my google sheet did a lot of heavy calcul…

[image] Nate_H: Plus, the strange part is, this was working completely fine for months, AFAIK until this morning… I’m seeing more of these reports in the past week. We’re looking into it. In the meantime, can you share your Team ID and App ID? Your Team ID is in the URL of your Glide dashbo…

Thanks Andy! Here you go: Team ID: dzOTuFSjeNjyZuZBUiEs App ID: YV3vT2Ddds9CMvqKmhpx

That’s right, everything works fine in the Google Sheet. When I manually sync Glide, it still doesn’t pick up anything but the first row where the actual ARRAYFORMULA is located. I definitely agree with your thoughts - medium / long-term we are likely to migrate this app to either Glide Tables or p…

Hopefully @NoCodeAndy can get you straightened out. I was about to suggest that maybe it’s a bug related to the other recent reports. I’ve been nervous about some of these recent issues, but so far I’ve been lucky, or just haven’t noticed yet.

ARRAYFORMULA no longer syncing from Google Sheets

Ask for Help

NoCodeAndy March 1, 2024, 4:11pm 12

I’ve started a thread in our Report a Bug category:

Topic		Replies	Views
Doesn't write on my Google Sheet Ask for Help	4	1866	January 25, 2020
Synchronization issues between google sheet and glideapps Ask for Help	10	125	October 7, 2025
Google Sheet Entries keep going to bottom of sheet in my glide app Report a Bug	10	714	October 16, 2022
Values not shown in glide table Ask for Help	4	253	July 31, 2022
How to retrieve data after duplicating and relation in Google sheets Ask for Help	17	995	February 24, 2021

ARRAYFORMULA no longer syncing from Google Sheets

Related topics