# Asana Sprint Status Reporter

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

Source: https://cotera.co/solutions/ops/asana-sprint-status-reporter

---

- **Team:** Operations
- **Tools:** Asana
- **Difficulty:** easy
- **Setup time:** 5 min
- **Time saved:** 30 min/standup

## How it works
1. **List Projects** — Finds all active projects in your workspace so you can target the right sprint board
2. **Pull Tasks** — Retrieves all tasks grouped by section to calculate how many are done, in progress, or waiting
3. **Find Blockers** — Searches for blocked tasks, overdue items, and unassigned work that needs attention
4. **Generate Report** — Produces a formatted sprint status with completion percentages and action items

## Example requests
- 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

## Prompt

```markdown
## Task

Use @Asana/List Projects to find active projects, then @Asana/List Tasks to pull tasks by section (To Do, In Progress, Done). Use @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 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 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 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]
```

## Related reading
- [Asana vs Monday.com: We Migrated and Then Migrated Back](https://cotera.co/articles/asana-vs-notion-pm-comparison.md)