1.4k
Savable complex boolean filters for any object type (AND and OR)
in progress
Bruce Cannon
We need the ability to create filter views using combinations of AND, OR and NOT, that act on not only task name text, but also spaces, lists, folders, labels, etc.
For example, each department (space) might have its own ideas or submissions section (list or folder). Those who plan dev priority would like to see a list view of just certain lists or folders across their org.
Or any custom selection, for that matter. Implying that the filter should allow for a simple "hide this item" in the view.
This new request was requested by @zeb-1 in the originating idea that got closed:
https://clickup.canny.io/feature-requests/p/advanced-filters-or-conditions "filters that allow for complex combinations of AND and OR logic across all the various attributes of tasks and projects"
Below are additional requests that could be folded under the same filter requirement:
https://clickup.canny.io/feature-requests/p/filterable-labels-for-folderslists "the ability to easily see a full list of web/creative projects currently being worked on."
https://clickup.canny.io/feature-requests/p/filter-by-list-name "Filter by List name to get all Tasks across all Folders that are in Lists with a particular name."
https://clickup.canny.io/feature-requests/p/filter-by-project-or-by-list-label-or-view-all-tasks-in-a-portfolio "Sometimes you need to see all tasks belonging to, say, high priority projects; or documentation lists for every project in progress."
https://clickup.canny.io/feature-requests/p/filter-for-both-andor-filters-at-the-same-time "((Due Date is Today or Earlier) OR (Start Date is Today or Earlier)) AND Location..."
https://clickup.canny.io/feature-requests/p/combine-filters-with-boolean-formulas "powerful filters such as "(overdue OR due in the next 7 days) AND (Not tag = to-do-at-home)""
https://clickup.canny.io/feature-requests/p/option-to-display-or-not-the-folderslists-in-gantt-view "some folder/lists are not part the of the gantt view"
Log In
Activity
Newest
Oldest
Justin Raine
SO glad to see this feature moving forward!
Shay Hill
Great news. I just left yesterday, mostly due to this issue. Ready to come back when this is resolved.
Brendan W
Shay Hill: You'll be back in no time!
Brendan W
in progress
P
Patryk Śliż
Brendan W: Yay!
John Ott
Brendan W: This is GREAT news!
David Nelson
Brendan W: oh thank god, this is so critical.
J
Joel MacPherson
Brendan W: Halelujah!
Jake Spirek
Brendan W: woot!
D
Dale King
Brendan W: Not holding my breath after waiting for years for this
Andy Craig
Brendan W: You love to see it!
A
Allen Krasna
Brendan W: I AM holding my breath !! - this will be the feature that has me move the entire team over!
Nigel Moore
Brendan W: Woohoo - this is SO needed!
Devin Shea
Brendan W: check out airtables somewhat new filter condition groups.

Brendan W
Dale King: Don't hold it, let it out!

Brendan W
Check above for a sneak peek 👀
Guy Mannerings
Brendan W: Boom!
A
Allen Krasna
Brendan W: Brendan if you need Beta people for this I am happy to help
Juan Angel
Brendan W: Awesome! Can't wait to try it out
Tanner Byas
Brendan W: Yay!!!!! Super stoked for this! :)
J
Jennifer Hall
This is so so needed. Any idea when this will happen? It makes using everything so much harder when you can't set filters to have and, or, not, all in the same filter. I have had to create additional custom fields to get around this limitation but still that only helps so much.
P
Patryk Śliż
Any updates? Without this 70% filters for me is useless :/
S
Strider
Can't wait for this to be implemented!
Sydney
Merged in a post:
Ability to Filter by ANDs and ORs
Destiny Pidgeon
I'd love it if I could filter my dashboards (and views too) by a set of ANDs and ORs at the same time.
This could be accomplished by grouping filters. For example, group 1 could be something like an option from a drop down field AND created before this date and group 2 could be a different custom field option AND created before this date. Then have an OR between the groups.
Sydney
Merged in a post:
Grouped filters for views/lists
Jake Spirek
Airtable does a great job of allowing grouped conditions.
Some are "this AND this" while others are "this OR this".
I tested a prototype for this probably last year but have heard nothing about it since then.
PLEASE, this is crucial for some of our views.
Since lots of my views need the AND criteria, I'm not able to use OR inside it. So instead, I have to list out all the things that I don't want in the list.
For example, I have a Sales Status field that I want to allow for 2 options to show, but I also have other criteria that need to be in place. In the current state, I have to use a ton of "Sales Status is not X" for each status that I don't want in there, instead of just choosing the 2 that I do want.
Please add this!
Sydney
Hi Jake! Thanks for your feedback. I merged your post into another similar post called "Ability to Filter by ANDs and ORs."
Jake Spirek
I think this is related, but posted it as a separate one just in case, so that others can search for it because the title of this one sounds a little different. https://clickup.canny.io/feature-requests/p/grouped-filters-for-viewslists
We really need to be able to group filters for AND/OR like you can in products like Airtable. I know this is something that Clickup was working on because I tested a prototype of it, but haven't heard anything about it since last year at least.
Load More
→