# Row IDs keeps auto populating

**URL:** https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948
**Category:** Ask for Help
**Created:** [December 14, 2021, 12:34pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948 "2021-12-14T12:34:01Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![RyanTan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryantan/32/41225_2.png) [@RyanTan](https://community.glideapps.com/u/RyanTan)
#### Post date: [December 14, 2021, 12:34pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/1 "2021-12-14T12:34:01Z")

</div>

Hi, i am unable to remove row IDs and it keeps auto-populating, causing import errors in my importrange function in my google sheet.

How do i remove Row IDs so they dont populate again?

Thank you

---

<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: [December 14, 2021, 12:44pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/2 "2021-12-14T12:44:20Z")

</div>

If you don’t need the RowID’s, then just delete that column.

If you do need them, then you’ll need to adjust your ImportRange so that it ignores that column.

---

<div class="post-metadata">

### Author: ![RyanTan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryantan/32/41225_2.png) [@RyanTan](https://community.glideapps.com/u/RyanTan)
#### Post date: [December 14, 2021, 12:57pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/3 "2021-12-14T12:57:21Z")

</div>

Thanks for your assistance!!

I have removed the entire column and replaced with another set of data.

However the Row IDs keep coming back.

I have also tried inserting a new column in my google sheets for my importrange to work but the data editor still overwrites my info in the new column with Row IDs.

---

<div class="post-metadata">

### Author: ![RyanTan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryantan/32/41225_2.png) [@RyanTan](https://community.glideapps.com/u/RyanTan)
#### Post date: [December 14, 2021, 1:04pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/4 "2021-12-14T13:04:37Z")

</div>

Attaching some screenshots of error,

What i need it as: (this is not by importrange but manual entry into the cell, still gets overwritten with Row IDs)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/db7768fc66221823efcea4ab2a6d28a3186320b9.png)

What gets populated after refreshing the Data Editor:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb8753c8a9746d818c5de3155ed700476ba2c2b3.png)

Hope this provides a better description!

---

<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: [December 14, 2021, 1:22pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/5 "2021-12-14T13:22:19Z")

</div>

> [@RyanTan](#):
>
> I have removed the entire column and replaced with another set of data.
> 
> However the Row IDs keep coming back.

Try this:

- Delete the column that contains the RowID from your Google Sheet.
- In the Glide Data Editor, force a sync with the Google Sheet, and visually confirm that the RowID column is gone
- Exit the Glide builder to the dashboard, then open the app again and check that the RowID column is gone.

---

<div class="post-metadata">

### Author: ![RyanTan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ryantan/32/41225_2.png) [@RyanTan](https://community.glideapps.com/u/RyanTan)
#### Post date: [December 14, 2021, 1:37pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/6 "2021-12-14T13:37:13Z")

</div>

Thanks! Did exactly that and it worked!

---

<div class="post-metadata">

### Author: ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)
#### Post date: [December 15, 2021, 1:38pm UTC](https://community.glideapps.com/t/row-ids-keeps-auto-populating/35948/7 "2021-12-15T13:38:05Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
