This is what happens when a tool that was never designed for complexity becomes the only tool we reach for. A single sheet, a few columns, a conditional formatting rule, it works beautifully until it doesn't. And by the time you realize it doesn't, you're already deep enough that starting over feels wasteful and forging ahead feels impossible. That tension is the story Miles Kettlepond is living right now, and it's a story we hear constantly.
The specific bug here is instructive. A formula that looks correct on paper, =AND(D2-TODAY()<=3, C2<>"Complete"), is returning TRUE on rows where the status is clearly "Complete." Miles suspects a hidden space issue in the dropdown values, and that is almost certainly the culprit. When you type validation lists directly into the data validation box instead of referencing a clean range, invisible trailing spaces creep in. "Complete" becomes "Complete " (with a space), and the formula sees two different strings. This isn't a spreadsheet failing. It's a spreadsheet faithfully executing logic against data that looks right but isn't. The fix is trivial: trim the values or rebuild the list from a range. But that fix only patches the symptom, not the deeper problem.
The deeper problem is structural. Every new column, every new summary tab, every manual drag of formulas down a growing list, these are all signs that the spreadsheet has outgrown its original purpose. A task tracker with a dozen rows is a checklist. A task tracker with a hundred rows, multiple criteria, cross-tab summaries, and senior-level breakdowns is a lightweight database running on software that was never meant to host one. The manual formula drags, the fragile COUNTIFS, the brittle conditional formatting, they all work until the next request comes in. Then you either rebuild or you fight the file. Miles is already fighting.
What we see here is a pattern that repeats across thousands of workflows. Someone starts with a simple need, solves it elegantly, and then the solution grows faster than the tool can gracefully handle. The spreadsheet becomes a trap not because it's bad, but because it's too accommodating. It says yes to every new column, every new formula, every new tab, until the weight of those yeses collapses into a single bug that takes hours to diagnose. The real question isn't how to fix the space in the dropdown. It's why we keep building databases in tools that were designed for napkin math.