smeautomation
Log inSign up free

Home · Jobs & career · Write a spreadsheet to track anything you name

Just ask 1 minUnder a minute

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.

Updated 17 Oct 2026

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.

Loading the outline…