# Finding and Deleting Duplicate Entries

**URL:** <https://community.glideapps.com/t/finding-and-deleting-duplicate-entries/71336>\
**Category:** Ask for Help\
**Created:** [March 1, 2024, 5:08pm UTC](https://community.glideapps.com/t/finding-and-deleting-duplicate-entries/71336 "2024-03-01T17:08:38Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [March 1, 2024, 5:19pm UTC](https://community.glideapps.com/t/finding-and-deleting-duplicate-entries/71336/2 "2024-03-01T17:19:44Z")

</div>

> [@Tyy](#):
>
> What happens when clicked is the data is removed from the sheet row, but the line itself isn’t removed. Since there is a RowID turned on, the row simply existing means that the original ID is deleted along with all the data, but then a new blank row still exists and that column is backfilled with a new RowID.

This suggests to me that you most likely have an arrayformula in the attached Google Sheet?  
Perhaps that’s used to flag your duplicates?  
If that’s the case, my suggestion would be to get rid of it and instead build that logic in Glide.  
It won’t solve the empty row issue in your GSheet, but it should prevent new RowIDs being added to those empty rows. Which may in turn solve the bigger issue.

That said, there have been reports recently of weird stuff going on with Google Sheet syncing. See below:

> [@Google Sheets stopped syncing? Let us know!](https://community.glideapps.com/t/google-sheets-stopped-syncing-let-us-know/71332):
>
> Hello Gliders! We’re seeing an increase in forum posts about Google Sheets sync issues. So far it seems to affect legacy apps with existing Sheets connections, where the automatic syncs started misbehaving about two weeks ago. We want to get all of these tracked in one thread to help our engineers troubleshoot. Please add your details to this thread if: You have an existing app with an existing Google Sheets sync Your sync was working fine until recently Reply with your Team ID and affect…

---

_[View the full topic](https://community.glideapps.com/t/finding-and-deleting-duplicate-entries/71336)._
