The Scenario
Your team lead sent a message at 4 PM: "Can you put together a workload breakdown before the 9 AM sync tomorrow? I want to see how tasks are distributed across the eight developers — open, in progress, closed — for the month."
It's a reasonable ask. It's also not something BugHerd surfaces natively across all projects at once. You'd need to go project by project, filter by assignee, count the tasks in each status bucket, and build the summary table yourself. Eight developers, five active projects each, three status buckets. The math on that is about two hours of clicking and counting.
The bad version:
- Open Project 1, filter by Assignee → select Developer 1, count the open tasks, write the number down, switch the filter to in-progress, count again, switch to closed, count again
- Move to Project 2, repeat the same filter dance for Developer 1
- Do this for all 8 developers across all 5 projects, then manually sum across projects per developer
Somewhere around the third project, you lose your place and have to recount. By the time you're done, it's 6 PM and the numbers still need to go into the sheet.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the workbook, queries BugHerd across all projects, and builds the summary table — no manual counting, no filter gymnastics.
List all BugHerd users and for each one count their open, in-progress, and completed tasks across all projects — write a summary table with one row per user, columns: Name, Open, In Progress, Completed
What You Get
- One row per BugHerd user in the summary table: Name in column A, Open task count in column B, In Progress in column C, Completed in column D
- Counts aggregate across all projects — not per project
- Users with zero tasks across all statuses are included with 0s, not omitted
- If a user has no assigned tasks at all, the row is still present so the team lead can see the distribution clearly
What If the Data Is Not Quite Ready
You need the breakdown per project, not just totals
For each BugHerd user, pull their assigned tasks grouped by project and status. Add the results to a new tab called Workload — columns: User, Project, Open, In Progress, Completed.
You want to filter to only the current calendar month
List all BugHerd users and count their open, in-progress, and completed tasks that were created or updated this month. Write a summary table with one row per user.
You need to exclude contractors and only show the core dev team
Pull open, in-progress, and completed task counts from BugHerd for these users only: [list the email addresses]. Write a summary table to the Workload tab, one row per user.
Kill chain: pull counts, highlight overloaded developers, flag capacity risk
List all BugHerd users and count their open tasks across all projects. Write a summary table — Name, Open Count — to the Workload tab. For any user with more than 15 open tasks, highlight their row in yellow and add 'CAPACITY RISK' to column C.
The capacity risk flags turn the data dump into an actionable list the team lead can address in the sync rather than after it.
Try It
Get the 7-day free trial of SheetXAI and open a blank Google Sheet, then ask SheetXAI to build a per-developer task workload table from your BugHerd account. Also see: Export All BugHerd Tasks Across Projects for Sprint Triage and the BugHerd hub.