# Some of the Glide column data not showing up after making changes in Google sheets

**URL:** <https://community.glideapps.com/t/some-of-the-glide-column-data-not-showing-up-after-making-changes-in-google-sheets/63356>\
**Category:** Ask for Help\
**Created:** [June 30, 2023, 4:23pm UTC](https://community.glideapps.com/t/some-of-the-glide-column-data-not-showing-up-after-making-changes-in-google-sheets/63356 "2023-06-30T16:23:28Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![devlin83](https://avatars.discourse-cdn.com/v4/letter/d/35a633/32.png) [@devlin83](https://community.glideapps.com/u/devlin83)\
**Post date:** [June 30, 2023, 4:23pm UTC](https://community.glideapps.com/t/some-of-the-glide-column-data-not-showing-up-after-making-changes-in-google-sheets/63356/1 "2023-06-30T16:23:28Z")

</div>

Column A contains static data, while all other columns contain array formulas that reference the data in Column A. Initially, when creating a Glide app, all the data loads correctly. However, if I add more data in Google Spreadsheets, it syncs properly to Glide. The issue arises when I delete the data in Column A and replace it with new or the same data. At that point, all the columns except for A and B stop syncing. I’ve been trying to troubleshoot this problem for a couple of days now. If you have any knowledge of how to resolve this issue, please help.

I have observed that if I replace the formula-calculated data with static data, the information appears correctly in Glide. Additionally, Column “Price” also contains a formula that displays data in Glide without any issues. Therefore, it seems unlikely that the issue is related to the formulas.  
Here is the link to the spraedsheet: [TrendMaster 1.2 - Google Sheets](https://docs.google.com/spreadsheets/d/1_GAlaS_mqBDhJ4Ko6RKtFaj-5dBPgQ7yMYxYzLIuS08/edit?usp=sharing)

 ![Screenshot 2023-06-30 at 12.05.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/2/428cc2d718f3819e265b4b5800cd801ffe459643.jpeg)  
 ![Screenshot 2023-06-30 at 12.06.39 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/9/c9c7947d78ec5abcb69980b9d75c3fa0996c0a33.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [July 1, 2023, 12:07am UTC](https://community.glideapps.com/t/some-of-the-glide-column-data-not-showing-up-after-making-changes-in-google-sheets/63356/2 "2023-07-01T00:07:01Z")

</div>

> [@devlin83](#):
>
> Column A contains static data, while all other columns contain array formulas that reference the data in Column A.

Can you explain why you use this approach, and does the arrayformula contain the column header?