The Scenario
The VP of Engineering has a board meeting in two weeks and wants a single slide showing issue distribution across all active Linear projects — the number of issues in Todo, In Progress, and Done for each one. Eight projects. Three states. The VP doesn't have time to click through every project's board view and copy numbers into a workbook manually.
The bad version:
- Open the first Linear project, look at the board view, count the Todo column, write the number down. Count In Progress. Count Done. Write those down.
- Navigate back. Open the second project. Repeat.
- By project 5 you realize the VP also wanted "In Review" as a separate state. Back to project 1.
The slide should take 20 minutes to build. The data collection is eating the whole morning.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It queries Linear for all active projects, counts issues by state for each one, and writes the summary directly into the workbook.
List all Linear projects and for each one count the number of issues in each workflow state, then write the results into this workbook with one row per project
What You Get
- One row per active Linear project.
- Columns for project name and issue count in each workflow state.
- Projects with zero issues in a state show 0, not a blank.
- A workbook that's immediately copy-pasteable into a slide or pivot table.
What If the Data Is Not Quite Ready
Only the four key states
Create a summary in this workbook with one row per Linear project showing the project name and the count of issues in Todo, In Progress, In Review, and Done states only
Exclude archived projects
List all active (non-archived) Linear projects and for each one write the project name, team, and issue counts in Todo, In Progress, and Done states into this workbook
Add a totals row
List all active Linear projects and write one row per project with the project name and issue counts for Todo, In Progress, In Review, and Done — then add a totals row at the bottom summing each state column
Full board-ready summary with percentage complete
For each active Linear project: write the project name, count of issues in Todo, In Progress, and Done states — then add a column showing the percentage of issues that are Done out of the total non-cancelled issues, rounded to one decimal place
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before your next leadership review — then ask it to pull issue counts across all your Linear projects into a summary table. Pair this with the sprint retro guide if you also need per-cycle velocity data for the same presentation.