If it’s any consolation/help, I use a free, external text-editor to write my formulas, and then copy-paste them into airtable.
Personally, I use VS Code to write them, which makes visualizing really long, hairy formulas much easier:
You don’t have to know anything about coding or how to use the text-editor in fancy ways. Just launch it, hit
cmd/ctrl + N to create a new document, and start typing. When you type
IF( it will auto-make the closing parenthesis for you - hit enter and it will auto-tab (indent) the next line for you - start typing the name of a field you’ve already typed earlier in the formula and it will suggest an auto-complete for you - etc…
Then, you can also save your formulas to your desktop or elsewhere, and when you need to add something, open it up and edit it in VS Code, and then copy and paste again to Airtable. It might make your life a little easier if you regularly write long formulas for Airtable.
Some other free options for text editors include Atom and Notepad++.