Filter out tasks that are due 60+ days from today

Seeking ideas of a suggested work around.

Context: Many projects I create for my team have due dates planned far in advance; often for a year out. Staff have expressed feeling overwhelmed and/or confused by seeing so many assignments and want their view to focus on what is imminent.

Ask: Within a project, I’d like to create a tab (list or board) that filters for tasks that are:

  1. Overdue
  2. Start Date has passed
  3. Due Date is within 60 days

Limitation I encountered using Filters: The maximum is “Due next 14 days” when I need “Due next 60 days” or even “Due next 30 days.” This product request is covered in the 2020 post: Expanded filter by due date

Limitation I encountered using Automations: I tried moving all long-term tasks to a collapsed “Pipeline” section and using an automation to bump them to an “Upcoming” section when the due date is within 60 days. However, this is not effective. The due date approaches without bumping the tasks appearing in the prioritized section.

Let me know if you see a way to improve my automation or have found another fix for this issue!

Welcome, @Moriah_Petty,

Here’s a simple workaround I’d recommend until/if Asana adds a filter like the one you mentioned.

Here’s an example of a single tab (List: Date) that could work for everyone (but see below for more):

It filters out completed tasks, and uses the Groups tab to implement grouping first by Assignee, then within Assignee, by Due date which Asana will dynamically adjust depending on tasks’ due dates. Note that both groupings hide empty groups (as shown) which eliminates blank sections which would otherwise clutter this view.

A variation, instead of the above, would be to create one tab per person. Keep the Grouping the same, but add the unique filter by Assignee = Moriah, for example, in your tab.

Hope that helps!

Another option is advanced search instead of a project tab. In the search filters set Due date to “Within the next” 60 days, then add In projects = your project and Completed = No.

Save it and your staff can open it as a saved search. It’s not a tab inside the project, but it rolls forward on its own, so no automation needed.