# Need help with a filter problem

**URL:** https://community.glideapps.com/t/need-help-with-a-filter-problem/30658
**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:** 1
**Showing post:** 20

<div class="post-metadata">

### 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, 3:28pm UTC](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658/20 "2021-08-20T15:28:28Z")

</div>

I think this should be really easy. All you need is a relation in your Staff sheet that uses the array and links to the project sheet. Then source the inline list from that relation and you are done. No filters needed.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/5/056764877c18c51c33e56f586e404f3efa17b02d.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5b07e6f7f949b3d095bc544303b9f4764a539cb0.png)

Once you get that part working, then you can use maybe a simplified version of this method below to allow the user to select projects more easily. Something that would build a joined list of selected projects and then a button to save that selection to the user’s record in the staff sheet. But lets get the relation part working first.

> [@Reset Multiple Rows At Once](https://community.glideapps.com/t/reset-multiple-rows-at-once/22211):
>
> There have been several requests for people to find a way to clear a value in multiple rows. I was thinking about that and came up with a quick example of a way to handle that. Instead of trying to clear a value in an entire column, I realized we could just change one value on a parent column, load it as a single value in our sheet and then compare that parent value to a column that we set or unset for each row. It’s not about clearing an entire column, it’s about making a value in each row n…

---

_[View the full topic](https://community.glideapps.com/t/need-help-with-a-filter-problem/30658)._
