Basically, I passionately hate the cramped awkward language that Google Sheets uses for formulas. Wouldn't it be super cool if there were a much nicer language you could work with that compiled back into Google Sheets? It'd be like CoffeeScript, but for Google Sheets, and with a browser extension so you could do it all seamlessly in Google Sheets.
So first off, there's some basic obvious stuff you'd want to do:
- Pretty printing: split across multiple lines, add indentation, add color coding
- Cleaner logical operators: replace
AND(x,y)
withx && y
, replaceIF(a,b,c)
with something likeif (a) { b } else { c }
, etc. - Better function names: kill the ALL CAPS regime, and give things clearer names (for example, why the hell does
FIND()
mean case-sensitive search andSEARCH()
means case-insensitive search?? how are you supposed to remember which is which??)
Beyond that basic cleanup, there's some further really complicated (but really convenient) stuff you coul