cotera

Asana Sprint Status Reporter

Pull sprint status from Asana automatically. See completion rates, blocked tasks, and overdue items without opening the board.

Sprint trackingCompletion ratesBlocker detectionOverdue alerts

The Challenge

Every standup starts the same way: someone opens Asana, scrolls through the board, counts tasks by section, and tries to remember which ones are blocked. By the time you've got a clear picture, you've burned fifteen minutes and the meeting is half over. The status report you promised the PM? That's another thirty minutes of clicking through tasks after the call.

What This Prompt Does

List Projects

Finds all active projects in your workspace so you can target the right sprint board

Pull Tasks

Retrieves all tasks grouped by section to calculate how many are done, in progress, or waiting

Find Blockers

Searches for blocked tasks, overdue items, and unassigned work that needs attention

Generate Report

Produces a formatted sprint status with completion percentages and action items

The Prompt

The Prompt

Task

Use @Asana/List ProjectsName it "Asana/List Projects" and call it with @Asana/List Projects to find active projects, then @Asana/List TasksName it "Asana/List Tasks" and call it with @Asana/List Tasks to pull tasks by section (To Do, In Progress, Done). Use @Asana/Search TasksName it "Asana/Search Tasks" and call it with @Asana/Search Tasks to identify blocked and overdue items. Calculate completion percentages and generate a sprint status summary.

Input

The user provides:

  1. Their Asana workspace or team name
  2. The project name or ID to report on (or "all active projects")
  3. The sprint date range (optional, defaults to current week)

Example: "Give me the sprint status for the Q1 Product Launch project"

Context

Project Discovery

  1. Use @Asana/List ProjectsName it "Asana/List Projects" and call it with @Asana/List Projects to find all active projects in the workspace
  2. Filter to the project(s) the user specified
  3. Note the project GID for subsequent task queries

Task Breakdown by Section

  1. Use @Asana/List TasksName it "Asana/List Tasks" and call it with @Asana/List Tasks to pull all tasks from the target project
  2. Group tasks by section: To Do, In Progress, Done (or equivalent section names)
  3. Calculate completion percentage: (Done tasks / Total tasks) * 100
  4. Track task counts per section

Blocked & Overdue Detection

  1. Use @Asana/Search TasksName it "Asana/Search Tasks" and call it with @Asana/Search Tasks to find tasks marked as blocked or with dependencies
  2. Search for tasks where the due date has passed and the task is not completed
  3. Flag tasks with no assignee that are in active sections
  4. Identify tasks that have been in "In Progress" for an unusually long time

Sprint Metrics

  • Total tasks in sprint
  • Tasks completed vs remaining
  • Completion percentage
  • Number of blocked tasks with reasons
  • Number of overdue tasks with how many days overdue
  • Unassigned tasks in active sections

Output

Sprint Status Report:

Project: [Project Name] Sprint: [Date Range] Overall Completion: [X]%

Section Breakdown:

  • To Do: [count] tasks
  • In Progress: [count] tasks
  • Done: [count] tasks

Blocked Tasks:

  • [Task name] - blocked by [reason/dependency]

Overdue Items:

  • [Task name] - [X] days overdue, assigned to [person]

Unassigned Active Tasks:

  • [Task name] in [section]

Summary: [1-2 sentence overview of sprint health]

Example Usage

Try asking:

  • →"Give me the sprint status for the Q1 Product Launch project"
  • →"Show completion rates across all active projects in our workspace"
  • →"Find all blocked and overdue tasks in the Mobile App Redesign project"