Google Chrome Extension to make long formulas easier to read
I created the chrome extension Anaplan Formulator to make long formulas easier to read in the native formula editor. The extension inserts a return before and after each IF, THEN, and ELSE in the formula. Please take a look and let me know what you think!
I do tend to agree that formulas should often be broken up if they are complex, but this is sometimes a battle against size issues in some models and longer/complex formulas is sometimes (but not always) the best option to limit space requirements.
Looking at our models, we probably should simplify in a lot of cases. But, as with almost anything, there are trade-offs to be considered.
Even simple IF/THEN formulas can benefit from the spacing that this add-in provides, however. So I still think it does have value. And for formulas that are already written and need to be simplified, I could see where this add-in might help to more easily identify the different pieces that could be pulled into separate line items to get back to a place where formulas are simpler.