# Need help with a filter problem **URL:** \ **Category:** Ask for Help\ **Created:** [August 18, 2021, 10:07pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658 "2021-08-18T22:07:33Z")\ **Posts on this page:** 6\ **Page:** 2
**Author:** ![nikatronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nikatronic/32/29921_2.png) [@nikatronic](https://community.glideapps.com/u/nikatronic)\ **Post date:** [August 20, 2021, 5:31pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/21 "2021-08-20T17:31:06Z")
Does my “current project array” have to be in the project sheet? Because currently it is in the staff sheet and when I try to create a relation column in the staff sheet, it gives me [this](https://drive.google.com/file/d/1LfPZOc1aHzNGktswiNtdLFDTcPEE7ndI/view?usp=sharing), cannot select an array. ---
**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:** [August 20, 2021, 6:32pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/22 "2021-08-20T18:32:54Z")
OK, let me ask this. Do you have an actual array, or are you just calling it an array? If it’s actually an array, the data editor will only show one column with all the values in the separate columns combined. Also, are you working with google sheets or glide tables? If you place all of your columns next to each other in a google sheet and sequentially number them, then they will combine and show in the data editor as a single array column. Your screenshot is showing gaps with other columns in between your project columns, so I’m suspecting that you do not actually have an array column. If you are using a glide table, then it will not automatically generate that array column. You then have to create a template column that joins all of the project columns together with some sort of delimiter, like a comma `,` or what I prefer…a pipe `|`. Then you use a Split column to split that template column on the delimiter to create an array. That’s why I asked to see a screenshot of your array column. I wanted to verify that you in fact do have an array column. And to answer your question…no you do not want to add anything to your project sheet. What I’m describing should only happen in the Staff sheet. ---
**Author:** ![nikatronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nikatronic/32/29921_2.png) [@nikatronic](https://community.glideapps.com/u/nikatronic)\ **Post date:** [August 20, 2021, 6:41pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/23 "2021-08-20T18:41:00Z")
I set up the numbered columns in the google sheet, then this was combined in the Glide sheet, so I guess I’ll have to create that template column now…😬 [Here](https://drive.google.com/file/d/10ipWh3ScRWsaVyfoFk5p_I5F1EttOYXP/view?usp=sharing)’s a screenshot of my current “array” in Glide and the according [columns](https://drive.google.com/file/d/1JKgzF6RL9wALam7HCkzkU9Vy5IHXhLDP/view?usp=sharing) in Google. ---
**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:** [August 20, 2021, 6:48pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/24 "2021-08-20T18:48:21Z")
Well, that seems correct. I feel like that should work. I’ll try to test it out myself later. So even if you scroll all the way down your list of columns when creating the relation, you still don’t see the array? Maybe it’s at the bottom of the list? You’ll still see the individual columns as options, but usually you should see the array intermixed in there. ---
**Author:** ![nikatronic](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nikatronic/32/29921_2.png) [@nikatronic](https://community.glideapps.com/u/nikatronic)\ **Post date:** [August 20, 2021, 6:52pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/25 "2021-08-20T18:52:02Z")
It works! 🥳🎈 That was great. Thank you! ---
**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:50pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/26 "2024-01-17T16:50:49Z")
Closed on January 17, 2024, 4:50pm UTC [Previous page](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658.md?page=1)