We have a straightforward opinion on this: the request to sync two columns across sheets without manual duplication should not require a Reddit post, a workaround, or a forum search. It should be a native, obvious feature of any modern spreadsheet tool. This user's ask, take column A and D from one sheet and mirror them to columns A and B on another, with edits and new entries updating automatically, is not exotic. It is a fundamental data management need. Yet the fact that this question exists, and that the user felt compelled to ask for help, tells us everything about the gap between what spreadsheet tools offer and what people actually need.
The practical reality for this user, and for anyone who has tried to keep two sheets in sync, is a cascade of fragile workarounds. They might use a formula like `=Sheet1!A1` dragged across cells, but that breaks when rows are inserted or deleted. They might try a macro, which requires coding knowledge and breaks if the file format changes. They might resort to manual copy-paste, which defeats the purpose of using a digital tool in the first place. Each of these options introduces friction, error, and wasted time. The user is not asking for a cutting-edge feature. They are asking for a basic function, data synchronization, that should be as simple as naming the source and the destination.
What this means in practical terms is that traditional spreadsheets treat data as static, isolated islands. They assume you will build your own bridges, formula by formula, and maintain them yourself. That model worked when spreadsheets were personal tools for small datasets. It fails when data is shared, updated, and referenced across multiple views of the same information. The user's request reveals a deeper truth: they want their data to be alive, not frozen in place. They want changes in one location to propagate automatically, so they can focus on the work the data supports, not on the mechanics of keeping it consistent.
We believe the solution is not a clever formula or a complex script. It is a fundamental redesign of how spreadsheets handle references. An AI-native spreadsheet should treat every cell as a potential data source that can be mirrored, filtered, or transformed in real time, without manual mapping. The user should be able to say, "Show me column A and D from that sheet, right here, and keep it current," and the tool should do it. No formulas. No macros. No forum posts. That is the bar. And until that bar is met, every workaround is a tax on human attention that technology should no longer collect.