Weekly updates from several PMs arrive in different formats, and turning them into one clear report for leadership takes longer than it should. This project status rollup report generator fixes that: paste every PM’s update into one box and get a single standardised one-page RAG report with headlines, blockers and next steps.
Format: one block per project, separated by a blank line. First line Project:, then PM:, Done:, Blocked:, Next:, Decision: or Ask: lines. RAG is suggested from your words (blocked/delayed = Red, risk/at risk = Amber, otherwise Green) and you can change it below. Nothing is uploaded; everything runs in your browser.
How to use the multi-project status rollup report generator in 3 steps
1. Paste the updates in blocks. Write one block per project, with blocks separated by a blank line. Start each block with Project: and the project name, then add PM:, Done:, Blocked:, Next:, Decision: or Ask: lines for the details. Each PM can keep writing in their own words; you do not need to reformat anything before pasting.
2. Check the suggested RAG and change it if needed. The tool reads each block and suggests a RAG status automatically: words like blocked, delayed, missed or overdue suggest Red, words like risk, at risk or concern suggest Amber, and everything else defaults to Green. The suggestion is only a starting point. Each project gets its own RAG dropdown under the report, so you can override any status before you share it. A realistic mix of Green, Amber and Red keeps the report honest and makes it useful for leadership instead of a list of empty greens.
3. Copy the roll-up as text or download it. The “Copy roll-up as text” button copies the full report so you can paste it into email, Slack or a document. The “Download report (.md)” button saves it as a Markdown file. Everything runs in your browser, so no updates are uploaded anywhere and there is nothing to sign up for.
Worked example
Sara reports steady progress on the website redesign while Omar flags a vendor delay on the app launch. The tool turns both into one standardised view:
| Project | PM | RAG | Headline |
|---|---|---|---|
| Website Redesign | Sara | Green | Homepage copy approved, 3 pages built |
| App Launch | Omar | Red | Vendor API delayed 2 weeks |
Cross-project blockers: App Launch: Vendor API delayed 2 weeks.
The roll-up keeps each project’s headline short and moves every blocker into one “Cross-project blockers” section, so leadership sees the one item that needs a decision without reading two full updates.
What RAG means in this report
RAG stands for Red, Amber, Green, a traffic-light scale used in project status reports. Red means a project is blocked or off track and needs a decision from leadership. Amber means a project is at risk and needs attention before it turns red. Green means the project is on track and needs nothing extra this week. The tool suggests a RAG status by scanning your words: blocked, delayed, missed or overdue suggest Red, risk or concern suggest Amber, and everything else stays Green. You can change any suggested status with the dropdown under the report, which matters because only you know the real context behind a PM’s wording.
Common mistakes
Copying updates word-for-word without a headline. Leadership scans headlines first, so a long paste of raw text defeats the purpose; keep each project’s Done and Blocked lines short.
Hiding blockers in long paragraphs. If a blocker sits inside a paragraph, it will not reach the cross-project blockers section; put it on its own Blocked: line so it is impossible to miss.
Reporting every project as Green. An all-green report trains leadership to stop reading; honest Ambers and Reds make the weekly roll-up worth their time.
Leaving next steps without an owner. A Next: line that names no one will drift, so always add the owner, for example “Next: Launch checklist with Sara” instead of just “Next: Launch checklist”.
Frequently asked questions
What should a weekly project status roll-up include?
Each project needs a headline, its RAG status, what was done this week, any blockers, and next steps with an owner. Keep it to one page: leadership wants the decisions and risks, not the full detail behind them.
How do I combine status updates from multiple project managers?
Collect each PM’s update in the same simple format, one block per project with Project, PM, Done, Blocked, Next, Decision and Ask lines, then use this project status rollup report generator to standardise them into one RAG table and a per-project summary. The consistent format means you stop rewriting everyone else’s words into a slide deck.
What does RAG mean in a project status report?
RAG is a traffic-light scale: Red means blocked or off track and needs a decision, Amber means at risk and needs attention, Green means on track. In this tool the status is suggested from your wording and you can override it with the dropdown under the report.
How do I write a one-page RAG report for leadership?
Start with a table of every project, its PM, its RAG and a one-line headline. Follow it with one short section per project covering done, blockers and next steps, then a single cross-project blockers section. That structure fits one page and gives leadership everything they need in five minutes.
Can I copy the roll-up into email, Slack or Word?
Yes. The “Copy roll-up as text” button copies the whole report as plain text, which pastes cleanly into email, Slack or Word, and the download button saves it as a Markdown file you can open in any text editor or documentation tool.
Related tools
Try more free browser-based tools from ToolBrewLab: Split Numbers, Epiweek, Formula Locker, Multi-tab Counter, Morning Routine.