# Delete Rows from User Profile Sheet

**URL:** <https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580>\
**Category:** Ask for Help\
**Created:** [January 1, 2021, 6:10pm UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580 "2021-01-01T18:10:17Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [January 1, 2021, 6:10pm UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/1 "2021-01-01T18:10:17Z")

</div>

I added a few rows to my Glide Data Editor user-profiles testing something out via a form, but it’s not displaying in my Google Sheet for me to delete, and I can’t delete it from the Glide Data Editor. Is this normal?

---

<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:** [January 1, 2021, 10:40pm UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/2 "2021-01-01T22:40:42Z")

</div>

Have you tried scrolling down the Sheet to see if they are there?

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [January 2, 2021, 12:51am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/3 "2021-01-02T00:51:21Z")

</div>

Yes, that was it! Thanks!

Do you know why that happens?

---

<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:** [January 2, 2021, 1:05am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/4 "2021-01-02T01:05:07Z")

</div>

Do you have any arrayformulas in your Sheet?

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [January 2, 2021, 2:00am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/5 "2021-01-02T02:00:59Z")

</div>

I just have Name, Email Address, Avatar and Row ID.

---

<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:** [January 2, 2021, 2:01am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/6 "2021-01-02T02:01:57Z")

</div>

Probably what you can do to prevent this is to clear all empty rows.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [January 2, 2021, 2:07am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/7 "2021-01-02T02:07:50Z")

</div>

Delete them from the Google Sheet? There is nothing in the rows but the first 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:** [January 2, 2021, 2:09am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/8 "2021-01-02T02:09:23Z")

</div>

Yes, you should delete all empty rows because Google might see empty rows as “filled” ones and write new rows at the end of the Sheet. It’s a weird API error that’s not in Glide’s control.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [January 2, 2021, 2:24am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/9 "2021-01-02T02:24:47Z")

</div>

Got it! Thanks!

---

<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:** [January 2, 2021, 5:15am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/10 "2021-01-02T05:15:08Z")

</div>

Jen - is this your “Public” Business Owners sheet? If you add rows to that sheet via Glide, it will break the arrayformulas.

---

<div class="post-metadata">

**Author:** ![Jen\_NYCP](https://avatars.discourse-cdn.com/v4/letter/j/848f3c/32.png) [@Jen\_NYCP](https://community.glideapps.com/u/Jen_NYCP)\
**Post date:** [January 2, 2021, 5:42am UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/11 "2021-01-02T05:42:14Z")

</div>

Oh no it’s my user profiles sheet, when someone creates a profile.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:58pm UTC](https://community.glideapps.com/t/delete-rows-from-user-profile-sheet/20580/12 "2024-01-17T16:58:29Z")

</div>


