Apple Numbers fails at tasks that any modern spreadsheet tool should handle effortlessly. The application lacks the ability to flatten a two-dimensional range, cannot dynamically reference multi-column data, and offers an incomplete function set that forces users into manual, repetitive, and error-prone work. Essential functions such as COLLECT and FLATTEN do not exist, and the limited array handling means that even straightforward operations require long, manually assembled ranges.Formulaic filtering of multi-column data is impossible without listing every range individually. Referencing large data structures remains clumsy and restrictive. Dynamic data spill into neighbouring cells is outright prohibited. Even simple tasks, such as generating a drop-down from another table, are impossible because Numbers does not support dynamic data validation. The result is a tool that obstructs automation instead of enabling it.On the Mac, common, universally expected keyboard shortcuts such as Cmd D and Cmd R for filling down or filling right are entirely absent. Even after manually mapping these shortcuts through System Settings > Keyboard Shortcuts > App Shortcuts, the functions refuse to trigger in Numbers, leaving users with no reliable or efficient way to perform basic autofill operations.Numbers may handle trivial budgets or single-table layouts, but any attempt to build structured worksheets exposes just how far behind it is. It performs like outdated software and lacks the core capabilities that users reasonably expect today.