what the hell is going on with “Tables” vs filter views vs slices vs named ranges.
That should all be one properly thought out feature. And tables are so fragile. Nobody knows how to use filters because they default to global. The row groupings feature is entirely broken and forgotten about… they recently updated the filter views UI to be fragile all e s as f throw error messages about whether you’ve saved the change or not (nobody ever cared about this, we’re just trying to filter without breaking the sheet)
The little pills you get for validated entries are nice though, but even that has like 3 different versions and ways to do it.
Then there’s things like checkboxes, I know there’s an option for it somewhere, but I have never once found the menu it lives in.
Oh and the paste style menu item that tells you the shortcut but doesn’t copy stole for you. That is the most written by an engineer feature I’ve ever seen. “You’re doing it wrong, do it my way now or don’t do it all”.
Some of it is just familiarity but I found Google sheets to be a breath of fresh air and still find Excel just painful.
Although Google has really gotten pretty cluttered lately as they add features and slap them in whatever menu they pick at random.
100%.
what the hell is going on with “Tables” vs filter views vs slices vs named ranges.
That should all be one properly thought out feature. And tables are so fragile. Nobody knows how to use filters because they default to global. The row groupings feature is entirely broken and forgotten about… they recently updated the filter views UI to be fragile all e s as f throw error messages about whether you’ve saved the change or not (nobody ever cared about this, we’re just trying to filter without breaking the sheet)
The little pills you get for validated entries are nice though, but even that has like 3 different versions and ways to do it.
Then there’s things like checkboxes, I know there’s an option for it somewhere, but I have never once found the menu it lives in.
Oh and the paste style menu item that tells you the shortcut but doesn’t copy stole for you. That is the most written by an engineer feature I’ve ever seen. “You’re doing it wrong, do it my way now or don’t do it all”.