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!
Just added and will be giving it a try! Did you create it? Any plans/thoughts on adding more functionality to it?
Hi @bdeaton, thank you for trying it out! I am the author. As of right now these are my goals for this project:
Short term - Create a GitHub page and publish as open source. I have high hopes for this project and believe the best way to see them come to fruition is to publish as free and open source.
Long term - Adding indentation functionality to make code look pretty. This feels like the next logical step in the extensions life.
Extremely long term - Fully functioning code editor. This would be really cool...lets see what happens.
Let me know if there is anything you would like added to the extension!
Thanks for sharing! I've also just added this extension, will take a look.
I'm used to copy-paste formula from a drilldown view to sublime text with C syntax. It helps with some complicated formulas.
Wow I didn't even know this existed. Will definitely check it out, Thanks!
"you should be able to explain the formula in a simple sentence"
"the formula should not take more space than the formula editor box"
If either of these is not true, then the formula is too big and should be broken up!!!
"simple is better than complex"
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.
I don't disagree!
I do think that anything that helps build better formula and understand existing formulas is welcome. Certainly the latter; where we are trying to simplify and optimise
@rmonique I've been using the add-in all day today. It's awesome!