# "Single Value" remains after all columns have been "Cleared" on an entire row **URL:** \ **Category:** Report a Bug\ **Created:** [December 26, 2020, 5:39pm UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317 "2020-12-26T17:39:31Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\ **Post date:** [December 26, 2020, 5:39pm UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/1 "2020-12-26T17:39:32Z")
I’m clearing all available columns in a row but a few Single Value columns will not go away. I’ve also cleared all blank cells in case there was some ghost info in there. I’m trying to get the rows to completely clear themselves out after a task is 100% complete. Any advice out there? My app’s URL: mgm.nowait.today ![Screen Shot 2020-12-26 at 11.32.22 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/80c8430ad20fbd838868ac8eb6324ba55e3fad20.jpeg) ---
**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:** [December 27, 2020, 12:50am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/2 "2020-12-27T00:50:31Z")
Why do you have 5 seemingly empty rows at the top? Is it a syncing issue? ---
**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\ **Post date:** [December 27, 2020, 1:14am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/3 "2020-12-27T01:14:55Z")
When an item on the list is completed, I have an action that clears all available fields. So you’re looking at old rows that will not disappear because clearing all rows doesn’t auto delete a row. I guess I have to wait for a “delete row” action. ---
**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:** [December 27, 2020, 1:19am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/4 "2020-12-27T01:19:21Z")
Do you have rowID in those rows? ---
**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\ **Post date:** [December 27, 2020, 1:57am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/5 "2020-12-27T01:57:28Z")
No… I have in the past and got rid of it in this solution but it didn’t help the problem. ---
**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:** [December 27, 2020, 3:17am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/6 "2020-12-27T03:17:34Z")
Can you try duplicating the app and point it to the same sheet to see if the problem persists? ---
**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:** [December 27, 2020, 5:11am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/7 "2020-12-27T05:11:20Z")
did you put any “” there? with arrayformula? it will keep a value ---
**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\ **Post date:** [December 27, 2020, 5:38am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/8 "2020-12-27T05:38:18Z")
It’s a Glide Sheet. All I know is the “Single Value” and “Template” columns don’t disappear when everything else is cleared… ---
**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\ **Post date:** [December 27, 2020, 5:38am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/9 "2020-12-27T05:38:36Z")
It’s a Glide Sheet ---
**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:** [December 27, 2020, 5:40am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/10 "2020-12-27T05:40:41Z")
just delete them in google sheets and add new ones ---
**Author:** ![Jonathon\_Kohn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jonathon_kohn/32/8593_2.png) [@Jonathon\_Kohn](https://community.glideapps.com/u/Jonathon_Kohn)\ **Post date:** [December 27, 2020, 5:53am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/11 "2020-12-27T05:53:26Z")
I don’t think you understand the issue. This is a glide sheet. All values are cleared via action. Single values and templates remain though nothing else in the row is there. This is not a Google sheet and my app sees about 1000 entries per week day. Manually deleting rows in the glide editor is going to be a nightmare. ---
**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:** [December 27, 2020, 6:16am UTC](https://community.glideapps.com/t/single-value-remains-after-all-columns-have-been-cleared-on-an-entire-row/20317/12 "2020-12-27T06:16:28Z")
I suppose since a Glide table more mimics an actual database instead of a spreadsheet…then that means a row is a row, whether or not all the columns are empty. Normal databases don’t have “empty” rows that are ignored. A row either exists or it doesn’t. Glide’s solution of ignoring empty rows in a spreadsheet is probably more of hack in a sense because new sheets typically start out with 1000 empty rows and it would be a lot of overhead for glide to process those empty rows all the time. A Glide table, on the other hand, is different because it’s more like a normal database and the only rows that exist are the ones that were created either manually or programmatically. To remove a row, you need to actually delete it. In my opinion, I would expect this kind of behavior from Glide Tables. In my experience with databases, you need to issue a delete command to delete a row. Simply clearing values does not destroy the row. In fact, in most indexed databases, you would run the risk of duplicate keys due to the indexed keys of rows matching each other and causing conflicts. Not so much here, as the table is either not indexed, or any indexed keys are hidden from our view. Point being that glide tables are most likely quite a bit different behind the scenes compared to spreadsheets. I more agree with your statement that we should have a delete action instead of automatically deleting rows based on cleared columns.