# How to filter row with multiple condition **URL:** \ **Category:** Ask for Help\ **Created:** [March 20, 2020, 12:47pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613 "2020-03-20T12:47:38Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Cjay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cjay/32/453_2.png) [@Cjay](https://community.glideapps.com/u/Cjay)\ **Post date:** [March 20, 2020, 12:47pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/1 "2020-03-20T12:47:38Z")
hi everyone, i’m struggling with filters. i can’t figure how to filter data with multiple conditions. Explanation: Create an App which objective is to share news. Users are classified by 3 differents categories : Job, Location and Status. The Objective: each user only has access to the news that concerns him. (right job, right location, right status) In user sheet, 3 colums : Job, Location and Status In news sheet 3 colums : Job, Location and Status with ‘Glide Relation’, i can filter all news by just one categorie (either job or location or status), but I can’t figure out how to do a filter with 3 differents categories at the same time… In googlesheet, it’s easy with query+OR+AND. But in glide … someone had any idea ? 😅 ---
**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:** [March 20, 2020, 1:22pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/2 "2020-03-20T13:22:07Z")
There are a couple ways to do this. 1. Create 3 relation columns in the news sheet. One for Job, one for Location, and one for Status. Then create 3 lookup columns to get the email addresses from each relation. Use the lookup columns to create 3 filters by signed in user. 2. Take your Job, Location, and Status columns and either rename the headings or use a formula to create 3 new columns with the headings ‘Filter 1’, Filter 2’, and Filter 3’. Do this in both sheets. This should allow you to use the Glide created ‘Filter’ array column to link both sheets together with a relation. Then create one lookup column to get email addresses to use for filtering by signed in user. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [March 20, 2020, 1:46pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/3 "2020-03-20T13:46:12Z")
My vote is option 2 ---
**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:** [March 20, 2020, 1:50pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/4 "2020-03-20T13:50:41Z")
Thinking about it more, option 2 might not work if you needed an exact match on all three. In that case: Option 3: create template columns in both sheets to join all three columns. Then use the template columns for the the relation and lookup. ---
**Author:** ![Cjay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cjay/32/453_2.png) [@Cjay](https://community.glideapps.com/u/Cjay)\ **Post date:** [March 20, 2020, 2:05pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/5 "2020-03-20T14:05:26Z")
whoo! you are fast ! thanks a lot ! i try the 3 option and let you know. 😃 ---
**Author:** ![Cjay](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cjay/32/453_2.png) [@Cjay](https://community.glideapps.com/u/Cjay)\ **Post date:** [March 20, 2020, 3:35pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/6 "2020-03-20T15:35:20Z")
it’s work perfectly great !! You are amasing ! Thanks you so much !!! Option 2 was the most adapt to my need. i own you one, if i can do something for you, just ask 🙏 🙏 ---
**Author:** ![FFT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fft/32/12706_2.png) [@FFT](https://community.glideapps.com/u/FFT)\ **Post date:** [August 31, 2020, 8:33pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/7 "2020-08-31T20:33:46Z")
Can anyone give an example of something similar? I want a sheet where at the top, users enter multiple conditions, and this dynamically creates a filtered list based on those conditions. thanks ---
**Author:** ![AyS\_0908](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ays_0908/32/27349_2.png) [@AyS\_0908](https://community.glideapps.com/u/AyS_0908)\ **Post date:** [August 31, 2020, 9:21pm UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/8 "2020-08-31T21:21:30Z")
Hi, maybe this can help > [@"Dynamic group-by" inline list](https://community.glideapps.com/t/dynamic-group-by-inline-list/14855): > > Hi, in case this is not a common workaround, happy to share an approach to have an inline list “dynamically grouped by” a choice component. This enables users to choose how to group-by the results of the inline list (+ to reduce the nb of inline list by x if we had 1 by ‘group-by’ criteria) Challenge: I’ve got 1 tab for [Search] and 1 for [Content]; I had to separate them because the [Search] tab displays elements of various tabs. In the [Search] tab, I have a ‘choice component’ for the ‘gr… ---
**Author:** ![FFT](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fft/32/12706_2.png) [@FFT](https://community.glideapps.com/u/FFT)\ **Post date:** [September 1, 2020, 9:22am UTC](https://community.glideapps.com/t/how-to-filter-row-with-multiple-condition/5613/9 "2020-09-01T09:22:25Z")
hi AyS, thank you, very similar to what I need, but is there a demo/template version I could follow? Struggling to follow your instructions even though they are clear because I am a beginner with glide. If you don’t want to release your app, could you release a mock up version with an example working? thank you