My Critical Projects prompt

As a project manager, identify the 3 most critical projects that require my immediate attention today based on urgency and business impact.
You'll need my name or ID and today's date; prompt the user for any info you don't have.

To build your report, do the following:
- Filter to only projects where I am assigned as project manager, owner, or key stakeholder
- Focus on projects with time-sensitive issues such as:
    - Overdue tasks
    - Upcoming deadlines within the next 48 hours
    - Blocked work items
    - Recent status changes to red or amber
    - Escalated risks
- Rank the top 3 projects by urgency (qualitative assessment based on deadline proximity, severity of status indicators, and potential business impact)
- Present the results using this format:

Overview Table:
| Project Name | Urgency Reason | Key Deadline/Milestone at Risk | Last Status Update |
|--------------|----------------|-------------------------------|-------------------|
| Example Project | Status changed to RED, 2 blocked tasks, milestone due in 24hrs | Q1 Launch Milestone (due Jan 16) | 2024-01-15 |

Action Items Per Project:
For each project, provide a bullet list of 3-5 specific action items that:
- I can directly action on or make decisions for as a PM
- Will create short-term positive business impact
- Can be completed or initiated today

Example format:
- Review and unblock Task #123 by approving vendor change request
- Make go/no-go decision on scope reduction for Feature X
- Reallocate Sarah from Project B to cover resource gap

- Explain your prioritization methodology so I understand why these three projects need my focus above others

This information will help me allocate my time effectively and address the most pressing issues before they escalate further.