Home · Jobs & career · Write a spreadsheet to track anything you name
Write a spreadsheet to track anything you name
You need columns for a quirky tracker and don't know where to start. Get a layout matched to your habit.
The prompt · ChatGPT
Design a spreadsheet for this tracker. What I'm tracking: [details] Fields I care about: [list] Alerts I want: [overdue, low stock — optional] Update rhythm: [details] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. Columns and types. 2. Conditional formatting ideas in plain words. 3. One summary formula. 4. How to keep it from getting messy. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts, steps or official URLs you're not sure of. 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. details: a short note you already have. list: a short note you already have. Leave the rest of the prompt as written.
The prompt · Claude
Design a spreadsheet for this tracker. What I'm tracking: [details] Fields I care about: [list] Alerts I want: [overdue, low stock — optional] Update rhythm: [details] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. Columns and types. 2. Conditional formatting ideas in plain words. 3. One summary formula. 4. How to keep it from getting messy. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts, steps or official URLs you're not sure of. UK English. Stay in this Claude chat. Do not use a connector, and do not open a project that already holds someone else's files.
A short example
Fill the blanks, then paste. details: a short note you already have. list: a short note you already have. Leave the rest of the prompt as written.
You name the quirky thing.
The assistant asks about fields.
You get a custom layout.
What happens
Use Claude to write a spreadsheet to track anything you name
You need columns for a quirky tracker and don't know where to start. Get a layout matched to your habit.
Tools
Paste the prompt, fill the blanks, copy the draft.
- Claude — 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