Advanced Filters with OR

Hi,

I’m very glad that Asana has recently implemented the ability to sort by multiple fields and filter the intersection of multiple fields. It’s getting closer to what I can accomplish in Notion currently, but Asana is limited in the following ways:

  • No ability to use the anti-filter for a Select field:


    I can only select to filter where the “Stage” field we have is one value at a time. I am not able to filter where Stage != Done. I am also not able to filter where “Stage” in (“Triage”, “Backlog”, “Planning”, “Ready”, “Dependent”, “In Progress”, “In Review”, “Late”, “Blocked”), which would be an acceptable workaround. Notion does currently support both of these features:
    image

  • No ability to add a filter with another field with an OR as opposed to an AND.
    Another issue referring to the same screenshot of Asana I posted above, there is no way to currently filter using the boolean OR across multiple fields in Asana. In my example, I am working on backlog grooming in Asana on long, old backlog where previous employees have not consistently used our Stage field or the Completion vs Incompletion in Asana. I would like to be able to filter to where “Status is incomplete” OR “Stage != Done”, to view all the tasks that we haven’t completed.

  • No nesting of filters
    image
    Notion has this capability already, where instead of just doing all ANDs or all ORs in your filter, you can specify the grouping/parentheses of the filters, allowing for more complex views and ease navigating.

18 Likes

This would be massively helpful.

4 Likes

This is one of the reasons because my team will leave Asana soon.

4 Likes

I agree that this filter would be very helpful. One of our use cases: in our Sprints we have a “Hot” field that shows urgent items that were added to the sprint unexpectedly. We also have regular work with due dates. We essentially want a “Now” tab showing all work that is due today or hot. These hot items are unexpected and may not necessarily have a due date.

1 Like

This logic seems pretty basic… is this a feature they are going to add in the foreseeable future? I have a project with multiple views, and each view is for a different User. For one of the Users/views, I’m trying to filter for two conditions, as in if one of two values is present, then that task should show up in that view. Can anyone think of any workarounds for this? I’m not able to add multiple filters, and when I add multiple filters within the filter option, there is no ‘Or’ logic with the filters.

@Michael_Sahl,

This may not apply to your particular use case, but ff you could use a multi-select custom field to represent the multiple conditions, you’ll be able to filter with what effectively is an “or”:

Also, re your multiple tabs for multiple users, could you simplify that with the Me (dynamic) filter which takes on the value of the logged in user?

I’ve merged your post into an existing topic where you can click the title to scroll to the top and vote by clicking the purple Vote button.

Thanks,

Larry

1 Like

Thank you just upvoted - unfortunately neither of your workarounds would apply. Appreciate the quick response!

2 Likes

Upvoted! Would be super super helpful to have and/or logic in the filters.

1 Like

I’ve got some cases for views that include multiple/combined values for a filter, for example:

  • Tasks that are either unassigned or assigned to me (filter out assigned to not-me)
  • Tasks that are (complete in the past 7 days) OR (incomplete and due in the next week)
  • Tasks that are either High priority OR due in the next week

Stuff like that. At the moment for example I can only choose ‘Task Assigned To Is Blank’ or ‘Task Assigned To Equals Me’ but not both.

@Dev_Lunsford1,

Does this request cover yours as well? If so, please reply and I’ll merge.

Also, Don’t forget to click the title to scroll to the top and vote by clicking the Vote button; that’s the quickest and most effective way to express your support for a request.

Thanks,

Larry

I don’t see another request to check? But if there’s another request that fits I’ll happily merge and vote.

1 Like

Whoops, sorry. I just edited my earlier post and added the topic I meant:

Thanks,

Larry

1 Like

Yes, this is perfect, happy to merge with that post. Thanks.

1 Like

Great; merged! Thanks!!

Adding my vote here, this would be a great improvement. It looks like it is the standard in any other platform right now, it would be nice to see it in Asana as well.

Voted! This is a big use case to help with data integrity (filter that has “if X OR Y OR Z OR A” data is missing, show the task. This will help us get our data hygiene in order and create one list vs. 10 different lists for each piece of metadata we need to chase down (Priority, Go-Live Date, Project Manager, Developer, Stakholder, etc.)

@Kennedy_Poirier FYI

Yes Yes Yes!! I am wanting to do similar.

Up voted!

Asana does not currently support criteria that include multiple filters on Due Date such as:

Due Date is Empty - or - Due Date is one of (Due before today, Due today, Due tomorrow, Due this week)

Currently, I cannot include the option of Due Date is empty with any other options for due dates past, present, or this week. Could Due Date “is empty” be added as an option when filtering Due Date is …

This is an enhancement I would like to see.

@Kari_Ankeney,

I’ve merged your post into an existing topic where you can click the title to scroll to the top and vote by clicking the Vote button.

Thanks,

Larry

Seriously, this is ridiculous. I am currently evaluating Asana since I am looking to upgrade from Trello to a more advanced tool. However, if there is no easy way to create a view with tasks that either have a specific field or is due today then this is useless. Even the simplest spam filter in an e-mail system has an OR operator, it should be super easy to implement. I had heard that Asana was more powerful and intuitive to use, but if such a simple function isn’t available I will have to look elsewhere.