Add Syntax Highlighting

Options
jeremy.paulmaz
jeremy.paulmaz Member, ALL USERS, GroupMember, Employee, Certified Model Builder Posts: 3 Occasional Contributor
in Planning & Modeling

As a Model Builder, I would like to have "syntax highlighting" when I create my formulas in order to improve readability.

Tagged:

Comments

  • mshcher
    mshcher Member, ALL USERS, GroupMember, Community Member Posts: 2 New Contributor

    I can't stress enough how important this would be to all model builders on the team. I would only like to point out that while the colorful highlighting is nice to have, the ability to add new line & indent while reading or editing the formula (similarly to how formulas are currently displayed when using Drill Down) would drastically improve readability by itself. This would be a huge quality of life improvement as going back to edit/read/understand/rewrite lengthy formulas would become much easier.

  • gvannier
    gvannier Member, ALL USERS, GroupMember, Employee Posts: 5 Occasional Contributor

    Fully agree with this huge improvement even we recommand to limit the length of formula in some case we can do differently.

     

  • Patrick
    Patrick Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    Hi everyone

    It will be helpful to have the arguments of a formula in a bubble (see the screenshot) while using that formula into the formula bar (much like in Excel). This will make understanding and learning easy.

     

    Regards,

     

    Patrick

  • MMAD
    MMAD Member, ALL USERS, Community Member Posts: 1 New Contributor

    Look in attached picture for example showcasing the problem -> How it works in excel. Look for syntax within red circle.

  • shamkataria
    shamkataria Member, ALL USERS, GroupMember, Community Member, Certified Model Builder Posts: 5 Occasional Contributor

    When entering a formula or you have completed a formula and line items references by it are highlighted or shading in a conditional format when in the formula bar - similar to excel. This would really help when you have similarly named line items or really long formulae.

  • Igor
    Igor Member, ALL USERS, Community Member Posts: 4 New Contributor

    +1, such functionality would remove a lot of pain and improve efficiency

    Dear @Rebecca , status of this idea was changed to "Considered for Future Roadmap" a year ago - is there any progress on a topic?

  • AndreyT
    AndreyT Member, ALL USERS Posts: 2 New Contributor

    +1 to: such functionality would remove a lot of pain and improve efficiency

    Cool features are always welcome especially when they are saving time.

  • matthew.mccurdy@slalom.com
    matthew.mccurdy@slalom.com Member, ALL USERS, GroupMember, Partner, Certified Model Builder Posts: 5 Contributor

    This would be a fantastic update to the platform. In the meantime, there are chrome add-ons you can leverage like A+ for Anaplan and Anaplan Formula Helper. They can be a little wonky at first, but once you get the hang of them it makes auditing long complex formulas much more manageable. 

Categories