# Your sheet needs a Row ID column first (yet Row ID exists)

**URL:** <https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648>\
**Category:** Ask for Help\
**Created:** [April 17, 2023, 9:25pm UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648 "2023-04-17T21:25:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kiptoo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kiptoo/32/57036_2.png) [@kiptoo](https://community.glideapps.com/u/kiptoo)\
**Post date:** [April 17, 2023, 9:25pm UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648/1 "2023-04-17T21:25:30Z")

</div>

I’m suddenly seeing this error when trying to add new rows to _some_ of my tables in the Glide Data Editor:

> ### **Your sheet needs a Row ID column first.**
> 
> Without a Row ID Glide can’t accurately add new data to this sheet.

 ![Screen Shot 2023-04-18 at 12.22.59 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/562031c34247fccb58f82426115dc3451bdcc7c5.png)

I use Google Sheets as my primary data source. The error started occurring after I renamed one of my sheets in Google Sheets (but reverting the renaming doesn’t resolve it). The layouts work all fine. It’s strange because I **already have row ID columns** in both the Google Sheet and the Glide tables.

I’d appreciate any ideas what’s causing this behavior and how to fix it.

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [April 17, 2023, 9:30pm UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648/2 "2023-04-17T21:30:01Z")

</div>

You lost row ID by changing the name of the column or sorting… you need to add a new one

---

<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:** [April 18, 2023, 1:28am UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648/3 "2023-04-18T01:28:51Z")

</div>

As Uzo said, there might be a point where you unknowingly changed the name of the rowID column and it got “disconnected”, so Glide now see it as a text column instead of a “rowID” column.

If it isn’t too much of a hassle (relating to the rowIDs being used in other tables), you can try removing the current column, and add a new rowID column to see if it helps.

---

<div class="post-metadata">

**Author:** ![kiptoo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kiptoo/32/57036_2.png) [@kiptoo](https://community.glideapps.com/u/kiptoo)\
**Post date:** [April 18, 2023, 9:09am UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648/4 "2023-04-18T09:09:17Z")

</div>

I didn’t really change the name of the column. As mentioned, I changed the _sheet_ name of the underlying Google Sheets table.

In any case, I had to recreate the row ID with these steps:

1. [In the Google Sheet] Rename existing Row ID column to “Old Row ID”
2. [Glide Data Editor] Attempt to add a new row to raise the “Your sheet needs a Row ID column…” alert. Click “Add Row ID”
3. [Google Sheet] Replace the contents of the (new) Row ID column with the values from “Old Row ID” to preserve any existing relations/lookups
4. [Google Sheet] Delete the “Old Row ID” old ID column
5. [GDE] Sync data manually for the changes to take effect

---

<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:** [April 19, 2023, 12:34am UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648/5 "2023-04-19T00:34:38Z")

</div>

> [@kiptoo](#):
>
> Replace the contents of the (new) Row ID column with the values from “Old Row ID” to preserve any existing relations/lookups

I suspect this will break things. When Glide syncs back the IDs from the Sheet, this will be read as “text” and not truthfully rowIDs, since they are not a match with what Glide has under the hood.

---

<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:** [April 20, 2023, 12:35am UTC](https://community.glideapps.com/t/your-sheet-needs-a-row-id-column-first-yet-row-id-exists/60648/6 "2023-04-20T00:35:08Z")

</div>

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