# We cannot create filters that are AND as well as OR, correct? **URL:** \ **Category:** Ask for Help\ **Created:** [August 21, 2020, 10:29pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369 "2020-08-21T22:29:31Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [August 21, 2020, 10:29pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/1 "2020-08-21T22:29:31Z")
For example: email is signed in user OR email is team manager AND archived is not true I have not found a way to do this and I really want to! šŸ˜ Just checking to make sure Iā€™m not missing anything! ---
**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 21, 2020, 10:33pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/2 "2020-08-21T22:33:50Z")
You are correct, but you can get creative by creating your ANDā€™s in the data editor and just use the ORā€™s in the filter. ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [August 21, 2020, 10:38pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/3 "2020-08-21T22:38:16Z")
Thank you Jeff! How would I put the andā€™s in the data editor? sorry haha- I am still learning every day! ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 21, 2020, 10:42pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/4 "2020-08-21T22:42:05Z")
Youā€™d just create a column in the data editor that creates all the conditions you need with AND. Then that column would be one of the OR columns in the component youā€™re filtering. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 21, 2020, 10:57pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/5 "2020-08-21T22:57:55Z")
For example: I want the component to filter when Color 1 is Red AND Color 2 is blue OR Color 3 is green. In the Data Editor I create an IF - THEN - ELSE column called ā€œColors 1\_2ā€ that checks the Color 1 and Color 2 columns and IF Color 1 is Red THEN true, IF Color 2 is not Blue THEN false, IF Color 2 is Blue THEN true, IF Color 1 is not Red THEN false. That column will check each condition one after the other and should give you ā€œtrueā€ if Color 1 has Red AND Color 2 has Blueā€¦ but ā€œfalseā€ if either of them doesnā€™t have its Red or Blue respectively. Great. Now go back to your component and filter it as such: Color 1\_2 is true OR Color 3 is Green. ---
**Author:** ![\_eric](https://avatars.discourse-cdn.com/v4/letter/_/5f9b8f/32.png) [@\_eric](https://community.glideapps.com/u/_eric)\ **Post date:** [August 21, 2020, 11:00pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/6 "2020-08-21T23:00:17Z")
John what about when you have tiered and/or conditions? And this image just involves two tiersā€¦ ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3f2e48f726fc1fbaf83d683c850de1d17f20eac1.png) ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [August 21, 2020, 11:00pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/7 "2020-08-21T23:00:51Z")
Ah, okay, now I get it. Thank you so much for the detailed explanation. I have used If/Then/Else but I didnā€™t think about it for this use case. ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [August 21, 2020, 11:02pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/8 "2020-08-21T23:02:02Z")
Having trouble understanding what you mean and I could probably get it if I could see the image, but itā€™s tiny and my eyes just arenā€™t what they used to be lol ---
**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:** [August 21, 2020, 11:52pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/9 "2020-08-21T23:52:15Z")
> [@new New containing screen context for conditions](https://community.glideapps.com/t/new-containing-screen-context-for-conditions/12316/5): > > [https://www.youtube.com/watch?v=gP2MWN0udU0&t=320s](https://www.youtube.com/watch?v=gP2MWN0udU0&t=320s) If you need to have an AND and an OR condition, use an if-then-else column first. For example, letā€™s say you want to a list of events that can only be edited by the event owner OR any app Admin AND only if the event hasnā€™t happened. Hereā€™s how: Create an if-then-else column in the data table from where the component resides (letā€™s name this column ā€œEditorsā€) Create your OR condition within this if-then-else column. For example, if you waā€¦ ---
**Author:** ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)\ **Post date:** [August 21, 2020, 11:53pm UTC](https://community.glideapps.com/t/we-cannot-create-filters-that-are-and-as-well-as-or-correct/14369/10 "2020-08-21T23:53:48Z")
Ah, I knew I saw this somewhere. Thank you!