# Active List And/Or Logic **URL:** \ **Category:** Lists, Lead Scoring & Workflows\ **Tags:** starter\ **Created:** [October 28, 2020, 11:51pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346 "2020-10-28T23:51:18Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![geopartin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/geopartin/32/87988_2.png) [@geopartin](https://community.hubspot.com/u/geopartin)\ **Post date:** [October 28, 2020, 11:51pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/1 "2020-10-28T23:51:18Z")
Hello! I am trying to create an active list with the following desired criteria. FieldA _and_ FieldB _and_ FieldC _and_ (Field1 **OR** Field2 **OR** Field3) The issue is there’s no way to flip an And to an Or within a single group. Are there any workarounds? ---
**Author:** ![geopartin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/geopartin/32/87988_2.png) [@geopartin](https://community.hubspot.com/u/geopartin)\ **Post date:** [October 28, 2020, 11:54pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/2 "2020-10-28T23:54:22Z")
Additionally for is there a way to switch “Is between” to number of days instead of calendar date? ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [October 29, 2020, 7:49am UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/3 "2020-10-29T07:49:30Z")
Hi @geopartin, The easiest way to do this is by building a second list: List 1: A and B and C and member of List 2 List 2: 1 or 2 or 3 Hope this helps! ---
**Author:** ![mike-ward](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mike-ward/32/26595_2.png) [@mike-ward](https://community.hubspot.com/u/mike-ward)\ **Post date:** [October 29, 2020, 1:28pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/4 "2020-10-29T13:28:29Z")
Karsten’s answer is detailed, but I think you missed the fact that **Field A** and **Field 1** are different Karsten. In your naming I think this would be: A and B and C and (X or Y or Z) The answer is right though @geopartin - this is a rather frustrating limitation of the current tool. You can either do this: A and B and C and X OR A and B and C and Y OR A and B and C and Z or you can make a second list. I would **definitely** vote for the second list option as Karsten mentioned already. It’s a pain, but it’s actually not unhelpful to have sub-lists like this, not least because you can standardize the definition of something and then re-use it. And it prevents the gymnastics or trying to do the logic above. @sharonlicari I was sure there was an Idea for this in the ideas forum to improve the conditional logic in lists. But I just searched and can’t for the life of me find it. Can you see if your search-fu is better than mine? We should all be upvoting that to improve this situation in the future 🙂 This has caught me out before and had some slightly painful business implications when I messed it up! Cheers, Mike ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [October 29, 2020, 1:32pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/5 "2020-10-29T13:32:05Z")
Thanks @mike-ward! Completely misread that. Thanks for pointing that out and the additional context, I’ve updated my previous post. ---
**Author:** ![sharonlicari](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/sharonlicari/32/101479_2.png) [@sharonlicari](https://community.hubspot.com/u/sharonlicari)\ **Post date:** [October 29, 2020, 4:42pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/6 "2020-10-29T16:42:36Z")
Thank you for the tag @mike-ward, I’m pretty sure Joe from the Ideas forum can help us with this. Hey @JoeMayall do you know if there is an idea similar to this thread? Thanks Sharon ---
**Author:** ![JoeMayall](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/joemayall/32/83822_2.png) [@JoeMayall](https://community.hubspot.com/u/JoeMayall)\ **Post date:** [October 29, 2020, 6:11pm UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/7 "2020-10-29T18:11:14Z")
Thanks @sharonlicari ! @mike-ward here are a few Ideas discussing alterations to the List logic. Was one of these what you were looking for? [https://community.hubspot.com/t5/HubSpot-Ideas/Allow-advanced-filter-logic-with-parentheses-for-lists-and/idi-p/252673](https://community.hubspot.com/t5/HubSpot-Ideas/Allow-advanced-filter-logic-with-parentheses-for-lists-and/idi-p/252673) [https://community.hubspot.com/t5/HubSpot-Ideas/Change-And-Or-Logic-on-Saved-List/idi-p/365995](https://community.hubspot.com/t5/HubSpot-Ideas/Change-And-Or-Logic-on-Saved-List/idi-p/365995) Here’s a [link to my search](https://community.hubspot.com/t5/forums/searchpage/tab/message?filter=location&q=conditional%20logic%20list&location=idea-board:HubSpot_Ideas&collapse_discussion=true). If you find the thread you had in mind, let me know as I’d love to upvote! ---
**Author:** ![mike-ward](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mike-ward/32/26595_2.png) [@mike-ward](https://community.hubspot.com/u/mike-ward)\ **Post date:** [November 2, 2020, 8:14am UTC](https://community.hubspot.com/t/active-list-and-or-logic/27346/8 "2020-11-02T08:14:25Z")
Thanks @JoeMayall and @sharonlicari - you’ve found it! This is the one I was looking for: [https://community.hubspot.com/t5/HubSpot-Ideas/Allow-advanced-filter-logic-with-parentheses-for-lists-and/idi-p/252673](https://community.hubspot.com/t5/HubSpot-Ideas/Allow-advanced-filter-logic-with-parentheses-for-lists-and/idi-p/252673) For anybody finding this thread in future, please add your upvote to that idea so it can get more visibility. I _suspect_ that while this would be a fairly trivial front-end change, it has larger implications for query performance on the server side, so it will need a fair amount of requests in order to make it to the roadmap. Let’s all upvote it and try and make it happen 🙂 Thanks, Mike