# ARRAYFORMULA no longer syncing from Google Sheets

**URL:** <https://community.glideapps.com/t/arrayformula-no-longer-syncing-from-google-sheets/71324>\
**Category:** Ask for Help\
**Created:** [March 1, 2024, 1:36pm UTC](https://community.glideapps.com/t/arrayformula-no-longer-syncing-from-google-sheets/71324 "2024-03-01T13:36:39Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [March 1, 2024, 3:12pm UTC](https://community.glideapps.com/t/arrayformula-no-longer-syncing-from-google-sheets/71324/4 "2024-03-01T15:12:33Z")

</div>

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.

> [@litter\_in\_bin\_sign Trash your Excel Formulas](https://community.glideapps.com/t/trash-your-excel-formulas/55788):
>
> 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_facepopcorn Enjoy! [[Glide: Replace 14 Excel Formulas with Glide Computed Columns] ](https://www.youtube.com/watch?v=YITKadLUKNE)

---

_[View the full topic](https://community.glideapps.com/t/arrayformula-no-longer-syncing-from-google-sheets/71324)._