Home · Jobs & career · Write a project plan in a sheet that shows what's late
Write a project plan in a sheet that shows what's late
A project with a deadline, a few people and too many moving parts. Get the tasks, owners and dates, in a Google Sheet that flags anything overdue.
The prompt · ChatGPT
Help me write a project plan. Goal: [what done looks like] Deadline: [date] People: [names and roles] Tasks I know about: [list] Things that could hold us up: [risks] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. A task table with columns: Task, Owner, Start, Due, Status, Depends on. 2. Milestones with dates. 3. A risk list: risk, likelihood, impact, what we'll do. 4. A weekly 15-minute check-in agenda. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts, dates or results. UK English. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
A short example
Fill the blanks, then paste. what done looks like: a short note you already have. date: a short note you already have. Leave the rest of the prompt as written.
The prompt · Copilot
Help me write a project plan. Goal: [what done looks like] Deadline: [date] People: [names and roles] Tasks I know about: [list] Things that could hold us up: [risks] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. A task table with columns: Task, Owner, Start, Due, Status, Depends on. 2. Milestones with dates. 3. A risk list: risk, likelihood, impact, what we'll do. 4. A weekly 15-minute check-in agenda. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts, dates or results. UK English. Stay in this Copilot chat. Leave plugins off, and do not open a file from OneDrive.
A short example
Fill the blanks, then paste. what done looks like: a short note you already have. date: a short note you already have. Leave the rest of the prompt as written.
You type the goal, the deadline, the people and the tasks you know about.
The assistant asks about dependencies and anything that could hold things up.
You get a task list with owners and dates, a risk list and a sheet that colours late tasks red.
What happens
Use Copilot to write a project plan in a sheet that shows what's late
A project with a deadline, a few people and too many moving parts. Get the tasks, owners and dates, in a Google Sheet that flags anything overdue.
Tools
Paste the prompt, fill the blanks, copy the draft.
- Microsoft Copilot — required. Drafts from the text you paste. Nothing is sent.
The prompt is on this page. A free account saves it.
Create a free account