Keeping It Simple and Kind to Future-You
Okay. This is it. Last lesson.
We built a dashboard the last couple weeks. You pulled your numbers in from your other sheets, you got a summary that shows you what's actually happening in your business without you clicking through six tabs to find it. That's a real thing you built. Sit with that for a second.
But before I let you go, I want to talk about the trap. Because there's a trap.
The trap
Now that you've got a dashboard that works, you're gonna want to make it fancier. I know this because I do it too. You'll add another chart. Another color rule. A second summary tab, then a third. Pretty soon you've got a dashboard so complicated that YOU can't remember how it works, let alone anyone else who might need to look at it.
Don't.
Simpler is kinder to future-you. That's not just an opinion I have, it's basically the whole reason I'm ending the course on this note instead of on "here's twelve more cool tricks." The clever formula you build today, the one that feels so smart when you finish it, is the one you will not understand in March. I promise you this. Future-you is tired and busy and does not want to reverse-engineer a puzzle that current-you thought was fun.
So here's what kind-to-future-you actually looks like in practice.
Name things clearly
Not "Sheet3." Not "Data2." Call it what it is. "Invoices 2026," "Inventory Master," "Dashboard, Don't Touch." If a formula references another tab, make sure that tab's name tells you what's in it without opening it.
Leave yourself notes
Right-click a cell, hit "Insert note," and write yourself a sentence about what that formula is doing or why that number looks weird sometimes. You will forget. Everyone forgets. A ten-second note now saves you a confused twenty minutes in six months.
Don't build what you won't maintain
If a feature takes you an hour to set up and you know you're not going to keep feeding it real data every week, skip it. A dashboard that's half-maintained is worse than no dashboard, because it looks official and it's lying to you.
Share a copy, not the original
Last practical thing. If anyone else touches this spreadsheet, a business partner, a family member helping you out, an employee, do not hand them the master file. Make a copy. File, Make a copy, and give them that. People overwrite your good stuff by accident. Every single time. Not because they're careless, just because that's what happens when two people are in the same sheet. Protect your original.
The kitchen thing
I want to tell you why I actually care about this, the room-being-manageable part, not just the spreadsheet part.
A while back I organized a game night and it turned into eleven people crammed into my kitchen. Way more than I planned for. And I remember the whole night was just me making sure everybody had a seat, or at least a spot on the counter, and a snack in reach, and nobody stuck awkwardly by the fridge not talking to anyone.
That's the same instinct I bring in here. A good dashboard, a good spreadsheet, a good class, it's not about how impressive it looks from the outside. It's about whether the person actually using it feels okay. Whether they can find what they need without getting lost in the back of the room.
I built a genuinely beautiful dashboard once for a garage-sale fundraiser. Spent a whole Saturday on it. Nobody looked at it. Not one person. I was bummed out the rest of the day, not gonna lie. But it taught me something real: the fancy version isn't the point. The person using it is the point. If your dashboard is simple enough that you actually open it every Monday, it's doing more good than the gorgeous one nobody opens.
One last practical pass
Before you close this out today, do three things:
- Open your dashboard and make sure every number on it still makes sense to you right now, today, without you having to think hard.
- Rename anything vague. Tabs, key cells, whatever.
- Make a copy of your whole workbook and label it something like "Backup, [today's date]." Takes thirty seconds. Google Sheets doesn't always save the way you think it does, especially if your internet's spotty, and up here on the bench between American Fork and the canyon, mine sure is sometimes.
Before next time
There isn't a next time, not in this class anyway. So instead of homework, just do this: open your dashboard once a week for the next month, even if it's just for two minutes. That's the whole trick. A spreadsheet only helps you if you actually look at it. ❤️