Add a simple formula builder to the platform
I believe this would be a very impactful tool for model builders and power users. The idea is to help write or verify a formula. In its most basic form, the tool would auto-indent formulas just like in an app like xcode:
X = Y
LOOKUP : LineItem
SUM : LineItem
A little version of that is already available in the drill-down functionality. In fact, I tell clients to use the drill-down functionality to check their formulas. If only the basic indentation of the drill-down menu would appear when you re-open the formula input field, already this would be a big improvement. Then if colors are added, it would make it even better. I suspect, doing this may require a level of syntax check as you enter the formula. This would go hand in hand with several other requests to check the syntax before submitting a formula, one of which is already on the roadmap:
A sort of formula builder that helps you structure a formula, analyze an existing large formula, and check the syntax would save a lot of time.
There are a few browser plug-ins circulating, to help with basic indentation of IF statements, which highlights the need for such a tool.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.