New Model Experience - Formula Editor Function Tool-Tip

To further enhance the modeling experience, particularly for new modelers, having a hovering tool tip when typing parameters within a function would be useful. It could be structured such that after typing the start of any function, a hovering display lists the required/optional parameters needed.

As an example, typing "Find()" would result in a hovering "FIND(Text to find, Text to search [, Starting character])" display above the cursor. This would lend to accelerating the learning of those just beginning their modeling journey, and increase overall experience.

When working with others new to the platform, it is not uncommon to see the formula editor reject the formula due to something as simple as flipped parameter order. Having a tool tip similar to the above could help alleviate this, and avoid increased troubleshooting time.

Comments

M.Kierepka

In the meantime, you might want to check a browser extension that has this useful functionality (and many others!): https://community.anaplan.com/t5/Anaplan-Platform/Better-Formula-Editor-for-Anaplan-A-new-Chrome-Firefox-Edge/m-p/138141

ChrisPang

As a new model builder, I am definitely in the category that's always putting the FINDITEM or LOOKUP parameters in the wrong order. This idea/feature request would be helpful!

Quick Links

New ideas

Data Validation Enhancement
Currently, Anaplan does not natively restrict number inputs to specific ranges. Users can input any numeric value, which may result in data integrity problems, especially in collaborative or decentralised planning environments. Introducing a validation capability—where model builders set upper and lower bounds for number…
Multiple approvers in workflow when using, "select user from a line item in a module”
Currently we can assign only 1 approver when assigning using "select user from a line item in a module”. There is no option assign the task to multiple approvers and have one of them approve the task. Even if we create 2 line items each for an approver, since it is a drop down, it is currently giving an option to select…
UX Enhancement: Red Font Toggle for Negative Numbers
In most cases, especially when adhering to accounting principles, it's preferred to display negative numbers in red font, similar to how Excel handles them. Currently, achieving this in Anaplan requires setting up conditional formatting for each line item, which can be time-consuming and inefficient. To streamline this…