# Blank in both GSheet and Glide data editor when users add profile data **URL:** \ **Category:** Ask for Help\ **Created:** [July 21, 2020, 10:17pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901 "2020-07-21T22:17:21Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![HeddaBO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heddabo/32/8531_2.png) [@HeddaBO](https://community.glideapps.com/u/HeddaBO)\ **Post date:** [July 21, 2020, 10:17pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/1 "2020-07-21T22:17:21Z")
Hi, in my app my sheets has started to look bland / empty when new users add data. Alla the calcs and filtering still works but sheets don’t populate. What could be wrong? @ThinhDinh could this be because I have array calcs based on profile data that is being added? ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 21, 2020, 10:25pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/2 "2020-07-21T22:25:17Z")
It’s strange that it’s not in the data editor. Try Command+Shift+Down Arrow in the sheet and see if it takes you to the missing data. I have this happen almost every time I set up a formula… ---
**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:** [July 21, 2020, 10:28pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/3 "2020-07-21T22:28:21Z")
Use of arrayformulas require you to delete all empty rows in the sheet. New records are always added to the bottom. ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 21, 2020, 10:30pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/4 "2020-07-21T22:30:02Z")
@Jeff_Hager, when I delete the empty rows, they just come back - what am I doing wrong? 😨 ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [July 21, 2020, 10:49pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/5 "2020-07-21T22:49:28Z")
@ThinhDinh don’t you sleep? 😆 ---
**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:** [July 21, 2020, 10:49pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/6 "2020-07-21T22:49:51Z")
As Jeff said, it’s likely the empty rows are the issue here. When Glide tells Sheets there’s a new row, Sheets see all empty rows as valid rows and won’t write to them. Therefore it will be written to row 501 or 1001 something. Another case is that you may have written “ “ instead of “” in your formula. ---
**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:** [July 21, 2020, 10:51pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/7 "2020-07-21T22:51:05Z")
Just woke up it’s almost 6 here lol. Watched a soccer match last night, Asians have a hard time following European sports, many matches are at 1 or 2am lol. ---
**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:** [July 22, 2020, 12:17am UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/8 "2020-07-22T00:17:00Z")
They shouldn’t come back unless you are maybe doing something similar to what’s happening in this thread. > [@Arrayformula storage issue](https://community.glideapps.com/t/arrayformula-storage-issue/9213/11): > > OK, I think I understand this a little better now. I don’t think I realized that your sheet was built from a unique formula. I think the rows are being created by google when the UNIQUE formula hits the end of the sheet and automatically adds the 500 rows as a buffer. I think what we have here is a non-issue. Since your are only building the sheet from a unique formula instead of a from a form button (this is what I thought was happening), you really don’t have to worry about the extra rows … ---
**Author:** ![HeddaBO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heddabo/32/8531_2.png) [@HeddaBO](https://community.glideapps.com/u/HeddaBO)\ **Post date:** [July 22, 2020, 11:21am UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/9 "2020-07-22T11:21:35Z")
Ah, yeah actually now I see them in the bottom. Is this okay or should I try to change the structure somehow? 🤔 ---
**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:** [July 22, 2020, 11:28am UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/10 "2020-07-22T11:28:37Z")
You should delete all the empty rows. ---
**Author:** ![HeddaBO](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/heddabo/32/8531_2.png) [@HeddaBO](https://community.glideapps.com/u/HeddaBO)\ **Post date:** [July 22, 2020, 11:31am UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/11 "2020-07-22T11:31:41Z")
Ok, thanks will do! Just out of curiosity - what’s the risk of having empty rows? ---
**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:** [July 22, 2020, 11:46am UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/12 "2020-07-22T11:46:53Z")
Just the thing I mentioned here. > [@Blank in both GSheet and Glide data editor when users add profile data](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/6): > > As Jeff said, it’s likely the empty rows are the issue here. When Glide tells Sheets there’s a new row, Sheets see all empty rows as valid rows and won’t write to them. Therefore it will be written to row 501 or 1001 something. Another case is that you may have written “ “ instead of “” in your formula. ---
**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:** [February 4, 2024, 2:17pm UTC](https://community.glideapps.com/t/blank-in-both-gsheet-and-glide-data-editor-when-users-add-profile-data/12901/13 "2024-02-04T14:17:02Z")