In Google Sheets there is one line at the top of the screen where you can type in a formula. As a programmer, after running into a few issues, the question comes to mind, is there an expanded view that has features like:
- larger entry area like a text area with multiple lines
- syntax highlighting*
- live processing of the function as you type it so you can see if it's working
- showing errors live or when clicking a button
- intellisense or auto complete*
*It looks like the current function text input already supports this.