Traditional spreadsheets have a way of turning a simple project tracker into a complex juggling act. The user who posted this query has spent a year building a project manager, only to hit the same wall: one sheet cannot easily hold projects, tasks, sub-tasks, completion percentages, and notes in a single, expandable view. Their solution of splitting everything across two sheets is a workaround, not a fix. The real issue is that the tool itself lacks the structural intelligence to handle hierarchy and nested data without manual gymnastics.
This is exactly where an AI-native approach changes the game. Instead of forcing you to manage multiple sheets or awkward dropdown menus, a smarter system can understand that a project header should automatically roll up the completion status of its tasks and sub-tasks. It can keep your notes attached to the right cell, whether that cell is a high-level project or a granular subtask, and let you back-reference without hunting through tabs. The user's desire for a "drop-down section" that reveals tasks and subtasks is not a feature request, it is a demand for a data model that mirrors how people actually think about work: layered, connected, and contextual.
What this means in practice is that you stop spending energy on the mechanics of organization and start focusing on the work itself. Imagine a single view where your project header shows a running percentage based on the tasks beneath it, where clicking a plus sign reveals the next level of detail, and where every note you type stays tethered to the exact item it belongs to. No more flipping between sheets. No more manual updates to a parent row every time a child task changes. The tool does the linking and the math for you.
For anyone who has felt the friction of managing complex projects in a flat grid, the message is straightforward: you are not asking for too much. The technology to build this kind of nested, intelligent view already exists. The challenge is not whether it can be done, it is whether you are using a tool that treats your project structure as a first-class citizen rather than an afterthought. A project planner should feel like an extension of your thinking, not a puzzle you have to solve every time you add a new task. That is the standard worth aiming for.