# Asana Standup Report Generator

> Generate daily standup reports from Asana task data. See what each team member did yesterday, is doing today, and what's blocked.

Source: https://cotera.co/solutions/ops/asana-standup-report-generator

---

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

## How it works
1. **Find Completed Work** — Searches for tasks completed since the last standup, grouped by team member
2. **Track In Progress** — Pulls currently active tasks with due dates and how long they have been in progress
3. **Surface Blockers** — Finds blocked, overdue, and stalled tasks that need attention or escalation
4. **Format Report** — Generates a clean per-person standup with yesterday, today, and blockers sections

## Example requests
- Generate a standup report for the Platform team project
- What did everyone on the Engineering team complete yesterday?
- Show me who\u2019s blocked and what\u2019s overdue across the Mobile App project

## Prompt

```markdown
## Task

Use @Asana/Search Tasks to find tasks completed yesterday, tasks currently in progress, and tasks that are blocked or overdue. Use @Asana/Get Task to pull full details on relevant tasks. Generate a per-person standup report with what they did, what they're doing, and what's blocked.

## Input

The user provides:
1. Their Asana project or workspace name
2. The team members to include (or "all" for everyone on the project)
3. The date range (optional, defaults to yesterday/today)

**Example:** "Generate a standup report for the Platform team project"

## Context

### Completed Yesterday

1. Use @Asana/Search Tasks to find tasks completed in the last 24 hours (or since the last business day)
2. Group completed tasks by assignee
3. Use @Asana/Get Task to pull task details like section, project, and any notes

### In Progress Today

1. Search for tasks that are currently assigned and in "In Progress" or equivalent sections
2. Include tasks with due dates today or this week
3. Note how long each task has been in progress

### Blocked or Overdue

1. Search for tasks that are marked as blocked or have unresolved dependencies
2. Find tasks where the due date has passed
3. Pull the blocking reason from task details or dependencies
4. Flag tasks with no recent updates that might be silently stalled

### Report Generation

For each team member, compile:
- **Yesterday:** List of tasks completed with brief descriptions
- **Today:** List of tasks in progress with context on what they're working on
- **Blockers:** Any tasks that are stuck, overdue, or waiting on someone else

### Formatting Guidelines

- Keep task descriptions brief (one line each)
- Include task links where possible
- Highlight overdue items clearly
- If a person had no activity yesterday, note it rather than skipping them

## Output

**Daily Standup Report — [Date]**

**[Person Name]**
- Yesterday: Completed [task name], [task name]
- Today: Working on [task name] (due [date]), [task name]
- Blockers: [task name] — waiting on [dependency/person]

**[Person Name]**
- Yesterday: Completed [task name]
- Today: Working on [task name], [task name]
- Blockers: None

**[Person Name]**
- Yesterday: No completed tasks
- Today: Working on [task name] (3 days overdue)
- Blockers: [task name] — blocked by [task in other project]

---

**Team Summary:**
- Tasks completed yesterday: [count]
- Tasks in progress today: [count]
- Blocked tasks: [count]
- Overdue tasks: [count]
```

## Related reading
- [Asana vs Jira: One Team Tried Both. Neither Won.](https://cotera.co/articles/asana-slack-integration-guide.md)