# Cleaning up your unused columns
**URL:** https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214
**Category:** Ask for Help
**Created:** [June 21, 2021, 8:23pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214 "2021-06-21T20:23:16Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 21, 2021, 8:23pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/1 "2021-06-21T20:23:16Z")
As you build your app and iterate quickly, you often create columns in order to try something, only to later discover there’s a better way. Eventually your Sheets and Tables are full of columns not being used at all, and likely never will be.
I’d like to propose a way for columns to be quickly identified as abandoned. Simply a mark or color on the column heading that shows it isn’t being used by any logical columns, relations, or components in the app would be very much appreciated.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 22, 2021, 2:14am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/2 "2021-06-22T02:14:17Z")
You’ve seen this, yeah?
> [@new Feature: "Find all uses" firefirefirefire](https://community.glideapps.com/t/feature-find-all-uses/28103):
>
> I’m up working on my app for my festival this weekend and look what I find. Nothing but music to my ears. Looking forward to using this!
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 22, 2021, 4:59am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/3 "2021-06-22T04:59:09Z")
I didn’t see this!!! I did a search trying to find any other threads for a feature like this, but came up with nothing. This is making me cry with joy.
Would be great if there was a way to quickly see without searching that the column isn’t being used. Even better if you didn’t actually have to click anything on the column to see it as @david suggests. Like some kind of color code or Mark on the column name itself. But I’ll take this as is! This is wonderful!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 22, 2021, 5:01am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/4 "2021-06-22T05:01:36Z")
yeah, it’s a game changer, that’s for sure.
Although not sure that it’s 100% reliable just yet, so I’ve been exercising a little bit of caution with it.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 23, 2021, 5:01am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/5 "2021-06-23T05:01:00Z")
I think we can move this one to the “Help & How-to” category 😉
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 23, 2021, 6:19am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/6 "2021-06-23T06:19:04Z")
For sure. especially since folks should probably know that this feature is NOT working perfectly as of the date of this reply. An array column set shows as not being used even if the individual columns in the array are being used. And in some cases Template columns aren’t registered being used when they are. Crippled my app last night with a couple deletes. Luckily it was easy to rebuild those columns and set things straight again.
---
### Author:  [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [June 23, 2021, 6:21am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/7 "2021-06-23T06:21:57Z")
even after yesterday’s update?
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 23, 2021, 6:25am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/8 "2021-06-23T06:25:22Z")
Well as of two seconds ago, the Emoji array column is telling me that it isn’t being used anywhere, but if I change the names of those columns in GSheets so they aren’t registered as a single array column, and look at each individually they are all being used. I don’t know about some of those template columns I noticed not registering, but I was cleaning my app up at around this time yesterday.
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 23, 2021, 6:26am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/9 "2021-06-23T06:26:40Z")
I’d be careful. I’m still finding broken stuff all over my app today because I got too excited about that feature.
---
### Author:  [@Manu.n](https://community.glideapps.com/u/Manu.n)
#### Post date: [June 23, 2021, 6:33am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/10 "2021-06-23T06:33:02Z")
I went through my app and didn’t notice any problem in this regard.
I had reported issues with the ifThen, lookup and rollup columns last week but everything was fixed yesterday and it works fine for me.
can you make a report or a little video to @Mark about the bug, so that he fixes.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [June 23, 2021, 10:54am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/11 "2021-06-23T10:54:30Z")
@John_Cabrera Could you give me a support link and tell me which column Glide is not reporting as being used, but which is actually used, and tell me where?
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 23, 2021, 5:39pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/12 "2021-06-23T17:39:35Z")
@Mark
> **[Remarkist](https://www.remarkist.com/)**
>
> We watch our favorite shows and movies together at the same time. Come join our watch parties and add your remarks!
in the Schedule sheet (which is a Google Sheet) there is an array column (in the data editor it’s the very last column). It shows that there are no uses anywhere in the app. However, if I rename those columns in Google Sheets so that they are no longer recognized as an array and then check each individual column in the array, they are each being used… so when bundled as an array, I would expect it to tell me that as well.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [June 23, 2021, 5:40pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/13 "2021-06-23T17:40:23Z")
Ah, I see! I hadn’t thought of that. Will fix. Thank you!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 23, 2021, 5:52pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/14 "2021-06-23T17:52:40Z")
@John_Cabrera just learned you “secret”. Very cool. Might have to share that with the GF.
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 23, 2021, 6:47pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/15 "2021-06-23T18:47:07Z")
She should join us, if she’s a fan of the show 😉 It’s been a really sticky project. Some big cast members joining us over the next week and months.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 23, 2021, 6:53pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/16 "2021-06-23T18:53:44Z")
She has the box set floating around somewhere. I’ll be sure to let her know. I feel like I need to watch it now. 😉
---
### Author:  [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)
#### Post date: [June 23, 2021, 6:59pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/17 "2021-06-23T18:59:15Z")
Find that box set. One of the big draws for fans is that I’ve never watched it. Not even my episodes. So it’s pretty geeky fun for me and for the rest of the community to hear my realtime reaction to the plot. The show is great great great. Not just a for women. It’s a really funny and deep series. You should get caught up and join us. We’re in S4 and the calendar goes through September… for this show 😉 If things keep progressing as they are, we’ll start something else, and I’ll try to pull some favors to have other awesome guests join us.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 23, 2021, 7:03pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/18 "2021-06-23T19:03:09Z")
Awesome! Will definitely check it out.
---
### Author:  [@Test\_Test](https://community.glideapps.com/u/Test_Test)
#### Post date: [March 25, 2022, 4:03pm UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/19 "2022-03-25T16:03:04Z")
> [@John\_Cabrera](#):
>
> ome kind of color code or Mark on the column name itself
Hi John,
You’re right, there are indeed too many unused columns (trees) which make it difficult to see the forest. How about taking your idea a step forward to something like Microsoft’s Excel “inspect spreadsheet” ? i.e. - generate a list of unused columns and allow us to mark the ones we’d like to delete, all in one swift process.
Thanks
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 26, 2022, 12:50am UTC](https://community.glideapps.com/t/cleaning-up-your-unused-columns/28214/20 "2022-03-26T00:50:13Z")
That would be very sweet.