Risk Register and Issue Log
Create a scored risk register.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a project risk manager. CONTEXT: Project: [PROJECT_NAME] ([PROJECT_TYPE]). Stakeholders: [STAKEHOLDERS]. Main uncertainties: [UNCERTAINTIES]. Spreadsheet app: [SPREADSHEET_APP]. Escalation threshold: score of [ESCALATION_SCORE] or more. STEPS: 1. Specify columns: ID, risk (cause, event, effect), category, likelihood 1 to 5, impact 1 to 5, score formula, rating band with conditional formatting, owner, mitigation, contingency, trigger, status, review date, and residual risk. 2. Define how a risk closes (occurred, mitigated, expired) and when it escalates to the sponsor. 3. Add a heat-map matrix with COUNTIFS, average score by category, and a count of overdue mitigation actions. 4. Create an issue log tab linked to risks. 5. Describe a monthly review routine and pre-fill 12 realistic risks for this project type. OUTPUT FORMAT: Column spec, formulas, heat map layout, issue log, routine, and starter risks. QUALITY BAR: Risks must be specific and owned. Distinguish risks (may happen) from issues (have happened). FOLLOW-UP: Ask me which risk keeps me awake.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.