Skip to content
Workflow · Age and chase · Opening soon

Asana overdue tasks by project and assignee

Export your tasks from Asana, then upload the file to Mammoth. The workflow counts open, overdue, and completed tasks for the current calendar week and groups them by project and assignee.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Asana tasks
    CSV export · 44 rows
  2. Step
    Count tasks and flag issues
    Step 1
  3. Result
    Asana Task Report
    22 rows
  4. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 22 rows.

What you get back

The result of that run, the rows to look at first.

Asana Task ReportSample data22 rows
ProjectAssigneeOpen tasksOverdue tasksCompleted this weekAssignee overdue flagNo-assignee overdue flagProject completion flag
Email Nurture RevampMaya Chen770More than five overdue·Completions in prior 14 days
Email Nurture Revamp·110·Overdue tasks with no assigneeCompletions in prior 14 days
Product Launch CampaignMaya Chen770More than five overdue·Completions in prior 14 days
Social Content Sprint·110·Overdue tasks with no assigneeCompletions in prior 14 days
Website Refresh Q4Ava Patel110Five or fewer overdue·Nothing completed in prior 14 days
Website Refresh Q4Lena Torres220Five or fewer overdue·Nothing completed in prior 14 days
Website Refresh Q4Maya Chen110More than five overdue·Nothing completed in prior 14 days
Website Refresh Q4Noah Kim220Five or fewer overdue·Nothing completed in prior 14 days
Website Refresh Q4Owen Brooks220Five or fewer overdue·Nothing completed in prior 14 days
Website Refresh Q4Priya Nair110Five or fewer overdue·Nothing completed in prior 14 days
Email Nurture RevampOwen Brooks001Five or fewer overdue·Completions in prior 14 days
Email Nurture RevampPriya Nair000Five or fewer overdue·Completions in prior 14 days
22 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Asana Task Report workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export your tasks from Asana, then upload the file to Mammoth. The workflow counts open, overdue, and completed tasks for the current calendar week and groups them by project and assignee. It also flags assignees with more than five overdue tasks, overdue tasks with no assignee, and projects with no completed tasks in the last 14 days.
What export should you use from Asana?
Use a task export that includes the fields needed for your report, such as task name, project, assignee, due date, and status or completion date. If a field is missing from the export, it cannot be used in the workflow.
What happens to rows that do not match the rules?
Rows that do not meet a rule are left out of that rule's result. For example, a task that is not overdue will not be counted in the overdue list, and a task without an assignee can be flagged separately.
How do you change the report rules?
Edit the wording of the workflow steps to change the rule. You can adjust which tasks are counted, which date window is used, and which conditions trigger a flag, then run the file again.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.