Report for Past Due/Overdue Only


#1

Hi Asana Community! My marketing agency is all-in with Asana and even uses it with clients now. Three clients have asked us how to run reports simply for “Overdue” tasks - managers want to know what their team members are behind on. They don’t care to see what’s due today - just everything that, as of the moment they run the report, is overdue. I can’t seem to figure out how to set this up within the Search parameters offered! Any advice is greatly appreciated.


#2

My first instinct was to try to use negative value inside the search but it does not work… I really don’t find any way to do this :frowning:


#3

My recommendation would be to run an Advanced Search for “Incomplete” Tasks, due in the “Next 0 days” and then sort by Due Date. This report will show tasks due today as well, but when you sort by due date, it will show in chronological order with today’s tasks at the bottom. You can also view the results in a calendar view to look at the tasks in the past few weeks on the days they were due.

The other option would be to use the due date option for “Between” and select the calendar dates for the past 1-2 weeks/months to find items past due for the past month or so. This however would require you to adjust the due dates when you want to re-run the report.

Do you think either of these options could work for your team and clients?


#4

Thanks so much @Kaitie and @Bastien_SIebman - Both good ideas, and things we had thought of…nothing seems to be a perfect fit. Seems like we’re going to have to run a report that does include “due today,” and just ignore those…

This seems like a super basic report - I’m surprised it doesn’t exist! Wouldn’t almost any manager of direct reports and numerous projects want to run a report, say, at the end of a week, just to see what’s overdue? :stuck_out_tongue_winking_eye:


#5

@Searcy_Morgan I used the search, and get a useful “pending . overdue tasks list”.
Hopefully this work for you.


#6

I’m struggling with this as well. With all the powerful search/filter capabilities in Asana, it really is an oversight that there is no way to restrict a search to JUST overdue items. Asana, please ADD this capability.