Create a Client-Ready Issue Log

What You Will Learn

You will learn how to use Gemini to turn risks, gaps, blockers, and open questions into a structured issue log with priority, owner, recommended action, due date, and resolution criteria.

Required Dataset

Use any workbook with findings, actions, risks, or open questions.

Recommended tabs:

Findings_Log

Project_Workplan

Workplan_Check

Create three new tabs:

Raw_Issue_Capture

Client_Ready_Issue_Log

Issue_Log_Check

Before You Start

An issue log is not just a list of problems. It should help management understand what needs attention, why it matters, who owns it, and what happens next.

Use issue types such as:

Risk

Gap

Blocker

Open Question

Decision Needed

Data Quality

Dependency

Use status values such as:

Open

In Progress

Blocked

Escalated

Resolved

Deferred

Step-by-Step Instructions

Step 1. Capture raw issues

In Raw_Issue_Capture, collect issues from findings, workplans, QA checks, stakeholder comments, or analysis gaps.

Use fields such as:

Raw Issue ID

Source Area

Raw Issue Text

Evidence

Initial Concern

Captured By

Capture Date

Needs Cleanup

Step 2. Ask Gemini to clean and structure issues

Use this prompt:

Act as a consulting project manager.

Convert the raw issues in Raw_Issue_Capture into a client-ready issue log.

For each issue, return:

Issue ID, Issue Type, Issue Description, Source Area, Evidence, Impact, Urgency, Priority, Owner Role, Recommended Action, Due Date, Status, Escalation Needed, Decision Needed, Resolution Criteria, and Notes.

Rules:

– Keep issue wording neutral and specific.

– Do not invent evidence.

– Recommended actions must start with an action verb.

– Resolution criteria must define what “done” means.

Paste the output into Client_Ready_Issue_Log.

Step 3. Add priority and escalation logic

Use priority values:

P1

P2

P3

Monitor

A simple priority rule is:

=IFS(AND(Impact=”High”,Urgency=”High”),”P1″,OR(Impact=”High”,Urgency=”High”),”P2″,OR(Impact=”Medium”,Urgency=”Medium”),”P3″,TRUE,”Monitor”)

Add an overdue flag if the due date is past and status is not resolved.

Expected Result

You should have a client-ready issue log with clear issue descriptions, evidence, priority, owner, recommended action, due date, escalation status, and resolution criteria.

Check Your Work

Confirm that every issue is specific, evidence-backed, neutral in tone, assigned to an owner role, and linked to a practical next step. P1 and blocked issues should be easy to identify.

Optional Extension

Ask Gemini:

Create a steering committee issue view from Client_Ready_Issue_Log. Include only P1, blocked, escalated, overdue, or decision-needed issues. Keep the output concise and decision-oriented.

How to get started

1

arrow-down-blue

Tell us about your project

2

arrow-down-blue

Interview candidates

(We’ll provide bios within 48 hours on average)

3

Select your consultant and start work

Find a Consultant

or email us at: [email protected]