A single Reddit post asking for help with a year-end projection formula reveals something important about the state of spreadsheet work today. The user knows exactly what they need, a simple "on-pace" calculation that takes January's sales and multiplies by twelve, but the act of translating that logic into a working formula has become a barrier. This is not a failure of understanding. It is a failure of the tool.
Traditional spreadsheets treat every calculation as a manual construction project. The user in this scenario is resourceful enough to ask for help, but the underlying dynamic is clear: even straightforward arithmetic requires a detour into formula syntax, cell references, and date logic. The solution they need is not complex. It is a ratio of days elapsed to days in the year, multiplied by current value. Yet the friction of implementing that logic in Excel turns a five-second mental calculation into a forum question. That friction is the real story here, and it is the reason a new approach to spreadsheets matters.
What this user actually wants is for the spreadsheet to understand time itself. They want to say "I have 10 sales so far" and have the tool recognize that "so far" means "partial year," then project the annual run rate automatically. That is not a formula problem. It is a design problem. An AI-native spreadsheet should treat time as a first-class concept, not something you must manually convert into a fraction of a year. When you enter data with a date context, the tool should offer projections without requiring you to build the logic from scratch. The user's job should be to define the question, not to write the algebra.
This is what we mean when we say the future of data work is accessible. The user in that Reddit thread is not asking for a revolutionary feature. They are asking for a spreadsheet that meets them where they are. That expectation is reasonable, and it is overdue. The tools we use should handle the structural work so that users can focus on the decisions those numbers support. If you have ever paused to Google a formula syntax while a simple projection sat in your head, you already understand why this matters. The next spreadsheet should do the math before you ask.