What question is this sheet answering? Write it down first
Okay sooo. We turned on autosave last time, so now nothing bad can happen to us. Kidding, plenty can still go wrong. But at least it won't be autosave's fault.
Here's the thing. Most people don't actually have a spreadsheet problem. They have a question problem. They open a blank sheet, and it just sits there, this big empty grid, and it's scary in a way that's hard to explain until you notice why. It's scary because there's no question in it yet. Nothing to organize around. So people start typing numbers into boxes because at least that feels like doing something, and three weeks later they've got a mess that doesn't tell them anything, because it was never built to answer anything in the first place.
So before you open Excel or Sheets today, I want you to do something that feels almost too simple. Write down, in actual words, one sentence, the question you want this sheet to answer.
Not "track spending." That's not a question, that's a vibe. Try "how much did we spend on groceries last month" or "which bills are due before payday" or "am I actually saving anything or just moving money around." A real question has an answer at the end of it. If you can't picture what the answer would look like, the question's still too fuzzy.
Why I make you do this first
I got handed a mess of contract renewal dates once, early on at a job, just a Word document, dates buried in paragraphs, and I was told to "keep an eye on it." I hated that within a week. Not because the task was hard, but because there was no question built into it. Keep an eye on it for what? What was I actually supposed to know at any given moment?
So I rebuilt it as a sheet. And the only reason it worked is I figured out the actual question first, which was "which contracts come due in the next 30 days." Once I had that question, the sheet basically built itself. Dates in one column, a formula flagging anything coming up soon, conditional formatting turning those rows orange. My manager started forwarding it around like I'd invented something. I hadn't. I'd just gotten annoyed enough to ask the right question before I touched the keyboard.
What this looks like at home
Grab a scrap of paper, actual paper is fine here, we're not building the sheet yet. Write down one question you have about your own life that a spreadsheet could answer. Some starting places:
- How much are we actually spending on groceries each month
- When are our bills due relative to when we get paid
- How many hours did I work last week across my two jobs
- What's left in our savings after this month's expenses
Pick one. Just one. Not five. If you write down five questions you're back to the blank-sheet problem, just with extra steps.
Now look at your question and ask: what columns would I need to answer this? For "how much did we spend on groceries last month," you probably need a date, an amount, and maybe a store. That's it. You do not need forty categories. That's a whole separate opinion I'll get into another day, but the short version is precision you won't maintain is worse than a rough number you'll actually keep.
The formula-pointing-wrong-column thing
Not gonna lie, I'll tell on myself here. My first real work sheet, the contract one, had a formula pointing at the wrong column for two straight weeks. Nobody caught it. Not my manager, not me. When I finally found it I went cold for a second, the way you do when you think you've broken something important.
Then I actually looked at what had gone wrong, and the numbers had been off in a way that didn't matter for what we were using it for. I sat there and laughed out loud, alone at my desk, because I'd been quietly stressed about nothing.
I bring this up because it's a good example of why the question matters more than the mechanics. If I hadn't known what question the sheet was answering, I wouldn't have been able to tell that the wrong-column error was harmless. I'd have just seen "the numbers are wrong" and panicked. Knowing your question gives you a way to sanity-check your own mistakes.
A quick caution
When you sit down to build the actual sheet next time, resist the urge to add "just one more column, just in case." That instinct is how six columns turns into forty. If a piece of information doesn't help answer your written-down question, leave it out for now. You can always add it later if it turns out you need it. You almost never do.
Before next time
Write your one question down somewhere you'll actually see it again, sticky note, notes app, whatever. Don't open a spreadsheet yet. Just sit with the question for a few days and notice what information you'd actually need to answer it.
- C