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 workaround but not an ideal solution long term. Any thoughts? I haven’t changed anything on either end…

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 Trash your Excel Formulas Community Resources wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column upside_down_face popcorn Enjoy! [Glide: Replace 14 Excel Formulas with Glide Computed Columns]

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 morning…

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 calculations (several minutes to process), and if Glide did a sync in the middle of those calculations, it did not get the latest data. I still have some things that I can only achieve in google sheets (or I can do it in glide, but would suffer a huge performance hit), so I use a handful of arrayformulas, import range, vlookups as well. But the things I’m doing don’t necessarily rely things being synced back to Glide instantly. Over the years I have moved a lot of computed logic into Glide, which has solved a lot of my problems because the google sheet performa it’s calculations much more quickly. If you resync the data via the data editor, does it pull in the values?

[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 dashboard, e.g. go.glideapps.com/o/your-team-id-here Your App ID is in the URL of the Glide builder, e.g. go.glideapps.com/a/your-app-id-here/layout

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 potentially a SQL data source so I will work out better solutions to issues like this at that time, or they’ll resolve themselves. But, we have to work out some things internally before I know what directly we’re going in so I don’t want to make a bunch of major changes before we get that figured out…

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	1890	January 25, 2020
Synchronization issues between google sheet and glideapps Ask for Help	10	195	October 7, 2025
Google Sheet Entries keep going to bottom of sheet in my glide app Report a Bug	10	752	October 16, 2022
Values not shown in glide table Ask for Help	4	279	July 31, 2022
How to retrieve data after duplicating and relation in Google sheets Ask for Help	17	1078	February 24, 2021

ARRAYFORMULA no longer syncing from Google Sheets

Related topics