What question is this sheet answering? Write it down first
Last time we turned on autosave, so now nothing bad can happen to us. I am teasing, of course. Plenty can still go wrong. But at least it will not be autosave's fault.
Most people do not really 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 is frightening in a way that is hard to put into words until you see why. It is frightening because there is no question in it yet. Nothing to gather around. So people start typing numbers into boxes, because at least that feels like doing something, and three weeks later they have a mess that tells them nothing, 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 will feel almost too simple. Write down, in real words, one sentence, the question you want this sheet to answer.
Not "track spending." That is not a question, that is a mood. 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 waiting at the end of it. If you cannot picture what the answer would look like, the question is still too fuzzy.
Why I make you do this first
I was handed a mess of contract renewal dates once, early on at a job, just a Word document, dates buried in the 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 meant to know at any given moment?
So I rebuilt it as a sheet. And the only reason it worked is that 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 nearly 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 as though I had invented something. I had not. I had only gotten annoyed enough to ask the right question before I touched the keyboard.
What this looks like at home
Grab a scrap of paper, real paper is fine here, we are not building the sheet yet. Write down one question you have about your own life that a spreadsheet could answer. A few places to start:
- 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 are back to the blank-sheet problem, only 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 is it. You do not need forty categories. That is a whole separate opinion I will get into another day, but the short of it is that precision you will not maintain is worse than a rough number you will actually keep.
The formula that pointed at the wrong column
I will tell on myself here. My first real work sheet, the contract one, had a formula pointing at the wrong column for two solid 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 have broken something important.
Then I actually looked at what had gone wrong, and the numbers had been off in a way that did not matter for what we were using it for. I sat there and laughed out loud, alone at my desk, because I had been quietly stressed over nothing.
I bring it up because it is a fine example of why the question matters more than the mechanics. If I had not known what question the sheet was answering, I would not have been able to tell that the wrong-column error was harmless. I would 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 does not 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 will actually see it again, sticky note, notes app, whatever suits you. Do not open a spreadsheet yet. Just sit with the question for a few days and notice what information you would actually need to answer it.
- C