Asana overdue tasks by project and assignee
“report our asana tasks across all projects: open, overdue and completed this week by project and assignee, and flag assignees with more than five overdue tasks, overdue tasks with no assignee, and projects where nothing was completed in the last two weeks”
Report our Asana tasks across all projects: open, overdue and completed this week by project and assignee, and flag assignees with more than five overdue tasks, overdue tasks with no assignee, and projects where nothing was completed in the last two weeks, using calendar week and prior 14 days.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
- FileAsana tasksCSV export · 44 rows
- StepCount tasks and flag issuesStep 1
- ResultAsana Task Report22 rows
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 22 rows.
- Download Asana tasks sample (44 rows)Asana: Project list > select marketing workspace > Export/CSV of tasks across projects
What you get back
The result of that run, the rows to look at first.
| Project | Assignee | Open tasks | Overdue tasks | Completed this week | Assignee overdue flag | No-assignee overdue flag | Project completion flag |
|---|---|---|---|---|---|---|---|
| Email Nurture Revamp | Maya Chen | 7 | 7 | 0 | More than five overdue | · | Completions in prior 14 days |
| Email Nurture Revamp | · | 1 | 1 | 0 | · | Overdue tasks with no assignee | Completions in prior 14 days |
| Product Launch Campaign | Maya Chen | 7 | 7 | 0 | More than five overdue | · | Completions in prior 14 days |
| Social Content Sprint | · | 1 | 1 | 0 | · | Overdue tasks with no assignee | Completions in prior 14 days |
| Website Refresh Q4 | Ava Patel | 1 | 1 | 0 | Five or fewer overdue | · | Nothing completed in prior 14 days |
| Website Refresh Q4 | Lena Torres | 2 | 2 | 0 | Five or fewer overdue | · | Nothing completed in prior 14 days |
| Website Refresh Q4 | Maya Chen | 1 | 1 | 0 | More than five overdue | · | Nothing completed in prior 14 days |
| Website Refresh Q4 | Noah Kim | 2 | 2 | 0 | Five or fewer overdue | · | Nothing completed in prior 14 days |
| Website Refresh Q4 | Owen Brooks | 2 | 2 | 0 | Five or fewer overdue | · | Nothing completed in prior 14 days |
| Website Refresh Q4 | Priya Nair | 1 | 1 | 0 | Five or fewer overdue | · | Nothing completed in prior 14 days |
| Email Nurture Revamp | Owen Brooks | 0 | 0 | 1 | Five or fewer overdue | · | Completions in prior 14 days |
| Email Nurture Revamp | Priya Nair | 0 | 0 | 0 | Five or fewer overdue | · | Completions in prior 14 days |
How it works
How to use the Asana Task Report workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Asana Task Report: questions
How do you report Asana tasks by project and assignee?
What export should you use from Asana?
What happens to rows that do not match the rules?
How do you change the report rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Age what is open, and get the list of who to chase, sorted by how late it is.
- DPO by monthDays payable outstanding for every month, with bills received and what was unpaid at month endSee the workflow Template
- AR agingWhat each customer owes, split into 1-30, 31-60, 61-90 and over 90 days overdueSee the workflow Template
- DSO by monthDays sales outstanding for every month, with credit sales and what was owed at month endSee the workflow Template
- Inventory agingEach product's stock split by how long ago it arrived: 0-30, 31-60, 61-90 and over 90 daysSee the workflow Template
- AP agingWhat you owe each supplier, split by how overdue it isSee the workflow Template
- Bad debt reserve from agingCalculate each customer’s bad debt reserve from QuickBooks AR aging exports and loss rates for each bucket.See the workflow Built by the agent