I agree that sheets is no excel, but it does almost everything I need, and a few things better. A few examples:
- JavaScript as a scripting language. (It's no python but it's nicer than vbscript.)
- Builtin regex functions (regexextract, regexmatch, regexreplace).