Skip to content

Compile Messy Workstream Check-Ins Into One Honest Weekly RAG Portfolio Brief

Synthesize uneven updates from 5+ project leads into a standardized Red / Amber / Green executive rollup that spotlights real risks instead of 'watermelon' green.

Copy the prompt and paste it into the AI assistant you already use.

How to cure 'watermelon projects' (Green outside, Red inside)

  1. 01

    Define objective triggers for Amber and Red so ratings aren't emotional

    Make Amber mean 'milestone risk >5 days OR unresolved dependency solvable within team' and Red mean 'target date/budget breached OR requires executive intervention this week.'

  2. 02

    Lead the rollup with Exceptions & Executive Asks—bury steady Green below

    Executives shouldn't hunt through four pages of 'On Track' prose to discover a blocked launch on page five; put Red/Amber items with explicit Asks in the top 10 lines.

  3. 03

    Always show Week-over-Week Delta (e.g., Green -> Amber) and Baseline Date

    Listing 'Launch: Nov 28 (Green)' hides that the original target was Oct 31; display 'Target: Nov 28 (Baseline: Oct 31) | Status: Amber (↓ from Green)' for honest visibility.

  4. 04

    Require a Path-to-Green owner and date on every Amber or Red row

    Reporting a Red flag without a mitigation plan or specific sponsor request is complaining, not program management—pair every exception with the exact unblock action.

How it works in practice

Raw Thursday Slack updates from 3 workstream leads

• Billing v2 (Nina): Stripe sandbox webhooks working! Still waiting 6 days on Tax team VAT rules, if not locked Monday we miss Nov 15 pilot. • SOC 2 Type II (Marcus): Evidence upload at 88%, on schedule for Dec 1 audit window. • Partner Portal (Dev): Designer pulled onto pitch deck all week, UI handoff slipped 8 days, no way Nov 10 holds unless we cut custom branding.

Executive RAG Portfolio Rollup (Exceptions First)

EXECUTIVE ATTENTION NEEDED THIS WEEK: • 🔴 RED (↓ from Amber) — Partner Portal | Target: Nov 18 (Baseline: Nov 10) - Blocker: Design lead pulled to sales pitch for 5 days. - Ask for CRO/VP Prod: Approve descoping custom logo theming from v1 today to hold Nov 12, OR accept Nov 18 slip. • 🟡 AMBER (↓ from Green) — Billing v2 | Target: Nov 15 - Risk: Waiting 6d on Finance Tax VAT rules; slips if open past Monday 12 PM (Escalated to Controller). ON TRACK: • 🟢 GREEN — SOC 2 Type II | Target: Dec 1 (88% evidence uploaded; 0 blockers).

Sorting Red and Amber to the top with binary executive asks turns passive status reading into immediate unblocking.

Common questions

Why are project managers afraid to mark a slipping project Amber early?

In unhealthy cultures, Amber triggers interrogation; leaders must explicitly reward early Week-3 Amber flags as smart risk management and penalize surprise Week-10 Red flips.

What day of the week works best for sending an executive portfolio rollup?

Collect raw 4-bullet workstream inputs Thursday afternoon and publish the synthesized rollup Friday morning by 10:00 a.m.—ahead of Monday leadership calls.

How long should the entire portfolio summary email be for 8 initiatives?

Under 350 words inline in the email body so any executive reads the full picture in two minutes, linking deep trackers for drill-down.

Learn more

Related guides and background articles for this task