# Google Sheet does not match data view in Glide **URL:** \ **Category:** Report a Bug\ **Created:** [November 12, 2019, 6:24am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903 "2019-11-12T06:24:32Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\ **Post date:** [November 12, 2019, 6:24am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/1 "2019-11-12T06:24:32Z")
One of the cells in my google sheet is showing checked. However, when I look at the data screen, it does not reflect the same information as the google sheet. Could this be a bug where the information is not syncing to a specific cell? ---
**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:** [November 12, 2019, 12:21pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/2 "2019-11-12T12:21:51Z")
Does Reload Sheet do anything? ---
**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\ **Post date:** [November 12, 2019, 12:41pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/3 "2019-11-12T12:41:16Z")
No. I tried several times. ---
**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:** [November 12, 2019, 12:43pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/4 "2019-11-12T12:43:38Z")
I have only seen a sync issue once, and that was due to a bug with the Lookup column, which was fixed. Any chance you have a lookup column? > [@Lookup sync problem with Google Sheets when submit](https://community.glideapps.com/t/lookup-sync-problem-with-google-sheets-when-submit/1356): > > I tried the Lookup feature in Data with a simple case : An USERS Sheet with NAME and EMAIL A SUBMISSIONS Sheet with only EMAIL A Column Relationship of EMAIL in SUBMISSIONS with USERS A Lookup Relationship in SUBMISSIONS to get NAME from USERS sheets It doesn’t seem to sync data to Google Sheets when I submit the form. If I remove Lookup relationship, it does work. ---
**Author:** ![mmgt2005](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mmgt2005/32/965_2.png) [@mmgt2005](https://community.glideapps.com/u/mmgt2005)\ **Post date:** [November 12, 2019, 1:02pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/5 "2019-11-12T13:02:31Z")
I don’t have a lookup column. There is a switch component which when true, checks all the checkboxes in a grouping. I am using the following formula for the cell. =if($CV$8=TRUE, true) $CV$8 is the switch. On the spreadsheet I am getting the right result for this cell. It just doesn’t sync will the data view in glide. All other cells are working. I’ve tried deleting the component and adding it back, but that’s not working either. ---
**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:** [November 12, 2019, 6:50pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/7 "2019-11-12T18:50:11Z")
I’m not sure what could be wrong. As long as the formula is the same for each column, I think it should work. Are you doing any special formatting on the column in the sheet? You could try deleting and re-adding the column in the sheet. Then deleting and re-adding the component. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 12, 2019, 6:52pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/8 "2019-11-12T18:52:31Z")
Would you mind sharing your app with us, please? ---
**Author:** ![apertur.co](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@apertur.co](https://community.glideapps.com/u/apertur.co)\ **Post date:** [November 24, 2019, 1:11am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/9 "2019-11-24T01:11:15Z")
I am having a similar problem – the Glide data sheet does not match the Google sheet. I’ve tried deleting the item from within the app, but that didn’t work either. Refreshed multiple times. Screenshots below. The extra row is highlight in the Glide data sheet. ![Screenshot%20(54)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/19caaeac2ce60da1010af8d3f1052b7227ed43f3.png) ![Screenshot%20(53)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/0ff43f78135f3ae89ff819d553315941b268a5f7.png) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 24, 2019, 3:52am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/10 "2019-11-24T03:52:43Z")
Could you share your app, please? ---
**Author:** ![apertur.co](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@apertur.co](https://community.glideapps.com/u/apertur.co)\ **Post date:** [November 24, 2019, 5:03pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/11 "2019-11-24T17:03:18Z")
It’s [https://choicecenter-demo.glideapp.io](https://choicecenter-demo.glideapp.io). The original problem seems to have gone away, but the same issue is in a different sheet now. In the attached screenshots, Victor appears only once in the Google Sheet, but twice in the Glide data sheet. ![Screenshot%20(57)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/ca1d718198e13091cd2b126f085bbb6b9d77e516.png) ![Screenshot%20(56)](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/927a898e454c4e1e5ca47798b8828dcc8d1e117a.png) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 24, 2019, 5:23pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/12 "2019-11-24T17:23:35Z")
I only see him once. Next time this happens, would mind reloading the browser window, and reporting back on whether that made the duplicate rows disappear? ---
**Author:** ![apertur.co](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@apertur.co](https://community.glideapps.com/u/apertur.co)\ **Post date:** [November 24, 2019, 5:27pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/13 "2019-11-24T17:27:19Z")
That might explain. I reloaded the sheet, but maybe not the browser. I’ll keep this in mind. Thanks! ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 24, 2019, 9:36pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/14 "2019-11-24T21:36:39Z")
Well, it shouldn’t happen at all. I’m ask you to reload the browser tab next time it happens and let us know whether that helped or not. That’ll help us figure out the cause of the problem. Do you know whether there’s anything you’re doing that leads up to there being duplicate rows? ---
**Author:** ![apertur.co](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@apertur.co](https://community.glideapps.com/u/apertur.co)\ **Post date:** [November 25, 2019, 1:20am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/15 "2019-11-25T01:20:30Z")
Thanks for your help, @Mark (my first name, too, BTW). The only cause I can think of is I might delete rows of data, in either the app or in Google Sheets. Perhaps that causes an error or delay when the app updates. I will keep my eyes open. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 25, 2019, 3:04am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/16 "2019-11-25T03:04:44Z")
@Mark It must have to do with deleting rows. In my case where I had those phantom or duplicate rows show up in the app, but not on the sheet, a script ran that cleared the sheet from row 2 on down and then added rows pull from a different spreadsheet. The script does a sheet.clear() and the loads all the rows needed from the other spreadsheet into an array, then calls a range.setValues(array) function. In my case it seems to always be the last row that is doubled up. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [November 25, 2019, 3:05am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/17 "2019-11-25T03:05:48Z")
I’ll try to reproduce that. Thank you! ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 25, 2019, 3:50am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/18 "2019-11-25T03:50:11Z")
How do you do this? Looks great ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/38808fa9b98e0a4f34a33ba6266dee2223501d09.jpeg) ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 25, 2019, 3:52am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/19 "2019-11-25T03:52:29Z")
Looks like markdown in a rich text component. ---
**Author:** ![apertur.co](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@apertur.co](https://community.glideapps.com/u/apertur.co)\ **Post date:** [November 25, 2019, 5:06am UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/20 "2019-11-25T05:06:45Z")
The logo is just an image with a lot of empty space on the left. It functions as a button to take the user to an “About” screen. “CHALLENGE PERIOD” is just a Glide Basic Text component. I fiddled around to determine the color and size of the header font (`color: #666666; font-weight: 400; font-size: 0.857em;`) so I could mimic it in the table. The table itself was a lot of trial and error in Markdown. Here’s the formula in the cell: ``` ="PROGRESS | Rank & name   |   To date   |   Week 3 (#)   |   Last   | | :--- | :---: | :---: | :---: | | 1. Victor | 7% | 1 | Today | | 2. Andrew | 0% | 0 | na | | 3. apertur.co | 0% | 0 | na | | 4. Claudia | 0% | 0 | na | | 5. Ernesto | 0% | 0 | na | | 6. Guusje | 0% | 0 | 1 d | | 7. Laura | 0% | 0 | 1 d | | 8. Lexi | 0% | 0 | na |" ``` This is built up from the first two rows + CONCATENATE of the column containing the per-user data. It’s all dynamic, based on the names or users and their posts. We’ve been warned that Glide may not support HTML formatting (the first line beginning with `" **Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 25, 2019, 6:03pm UTC](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903/21 "2019-11-25T18:03:52Z") Excellent thank you, very creative you are a master! [Next page](https://community.glideapps.com/t/google-sheet-does-not-match-data-view-in-glide/1903.md?page=2)