Turn my team's updates into a weekly RAG status report
Pulls scattered team updates into a weekly status report with honest red-amber-green ratings, risks, and asks.
The prompt
Turn my team's updates into a weekly project status report with RAG ratings.
Project name and goal: [ONE LINE]
This week's updates: [PASTE emails, Teams or Slack messages, stand-up notes, tracker exports]
Plan baseline: [KEY MILESTONES and dates, budget if tracked]
Last week's status: [PASTE, if available, so you can show changes]
Readers: [team / sponsor / steering committee]
Use these RAG rules unless I give my own:
- Green: on track for the next milestone and the end date; no help needed.
- Amber: at risk; a recovery action exists and is in hand.
- Red: will miss a milestone, budget, or scope commitment without a decision or help from above.
Rate overall status and each of: schedule, scope, budget, resources, risks. Don't let a good mood in the updates override the facts: if a milestone date has moved, schedule can't be green.
Return:
1. Headline: overall RAG plus one sentence on why.
2. Table: Area | RAG | Change vs last week (up/down/same) | Reason.
3. Done this week (3-6 bullets, outcomes not activity).
4. Next week (3-6 bullets with owners).
5. Top risks and issues: what, impact, owner, action, due date.
6. Decisions or help needed, with who must act and by when.
Keep it under 350 words. Flag any update that contradicts another, and any missing workstream, as [CHECK]. Don't invent progress, numbers, or dates.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Projects & Operations prompts
What to fill in
- ONE LINE
- KEY MILESTONES and dates, budget if tracked
- PASTE, if available, so you can show changes
- team / sponsor / steering committee
- CHECK
How this prompt is built
This prompt follows the RTF structure (Role, Task, Format). RTF tells the model who to be, what to do and what shape the answer should take. It is the quickest structure that still gives noticeably better results than a bare request.
Related prompts
- Build a one-page project dashboard for executives in Excel or PowerPointDesigns a one-page project dashboard with the right KPIs, RAG indicators, and layout, built from your project data.
- Write a banquet event order for a wedding or functionA complete BEO that tells kitchen, banquet, AV, and setup teams exactly what to deliver and when.
- Plan a move to new accounting softwareBuilds a migration plan with data mapping, cutover date, opening balance checks, and parallel testing so nothing is lost.
- Reduce excess and obsolete inventory with a disposal planIdentifies slow-moving and obsolete stock, sorts it by recovery option, and builds a plan to free cash and prevent recurrence.