The Scenario
A product manager is preparing for the all-hands next week. The exec team wants a single timeline slide showing every upcoming milestone across all active Linear projects — project name, milestone name, and target date, sorted chronologically. Eight active projects, 30-plus milestones total. The PM is discovering that Linear's UI doesn't make it easy to see milestones across multiple projects at once.
The bad version:
- Open the first project in Linear, navigate to Milestones, note down each milestone name and target date.
- Open the second project, navigate to Milestones again, note them down.
- Eight projects. The dates are in different formats depending on how different team leads entered them. By the end, you've gone back to fix a wrong date twice and you're not confident the sort is right.
The all-hands prep has consumed an hour and a half.
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 and their milestones, then writes the full list — project name, milestone name, and target date — into the workbook in sorted order.
List all Linear projects and for each project fetch its milestones, writing the project name, milestone name, and target date into columns A, B, and C
What You Get
- One row per milestone, across all active Linear projects.
- Columns for project name, milestone name, and target date.
- Projects with no milestones are skipped rather than generating blank rows.
- Dates written in a consistent format, ready to sort in the workbook.
What If the Data Is Not Quite Ready
Sort by target date, not by project
Pull all milestones for every active Linear project into this workbook sorted by target date ascending, with columns for project name, milestone name, and target date
Only milestones with a date set
List all Linear projects and for each one fetch milestones that have a target date set — write project name, milestone name, and target date into this workbook sorted by date
Filter to milestones in the next 90 days
Pull all milestones across active Linear projects that have a target date within the next 90 days, write project name, milestone name, and target date into this workbook sorted by date ascending
Full roadmap view with overdue flags and team attribution
List all milestones across all active Linear projects: write the project name, team name, milestone name, target date, and a column marking "overdue" if the target date is before today or "upcoming" if it is not — sort by target date ascending
Try It
Get the 7-day free trial of SheetXAI and open a blank Excel workbook before your next all-hands prep — then ask it to pull the full milestone roadmap across all your active Linear projects. Pair this with the cross-project issue count guide if the exec team also wants to see current workload alongside the timeline.