Issue with formula editor :clicking on a list or list item does not work anymore (e.g. for finditem)
Since the new formula editor release, I noticed that when I am editing a formula and go and click on a list or list item, the formula does not get populated with the list / list item. Now instead, I need to type the name of the list (e.g. when using FINDITEM or ITEM formula). This is bad!
Is anyone else having the same issue?
Update Dec 2nd 2021. Message from Anaplan support
I have received a response from the Product team and I am pleased to inform you that this issue is currently planned to be fixed as part of our product roadmap. I will place this case on hold until that time and reach out to you once the fix is released.
Anaplan support got back to me confirming this is a know issue
No updates on when the issue will be fixed0
This issue only happens in the new model experience.
So another workaround is going back to the "old" model experience. I tried it and it works.0
I have the same issue.1
Jeez! Definitely not good. Time to raise it to Anaplan Support. Did you already? If so, please update the thread as well.
Note: However as part best practices, List items are not supposed to be hard coded/referenced (be it structural or production) as it hinders the Scalability of the model.
Thank you @Misbah and @CarolineJosefsson for confirming.
I opened a ticket with Anaplan support and I'll update this thread when I hear back from them
@Misbah Totally agree with your statement about not hard coding list items. I used it as an example to illustrate how the formula editing had changed and was not working as expected.
Side note: it is OK to reference the Top Level item with SELECT and that's not working either.
Definitely something went wrong with the formula editor when the new changes were made.1
Not just ok.. More than ok to do that🙂
Thanks and please update the thread as and when you hear anything from anaplan support.0
Message from Anaplan support on dec 2nd 2021
I have received a response from the Product team and I am pleased to inform you that this issue is currently planned to be fixed as part of our product roadmap. I will place this case on hold until that time and reach out to you once the fix is released.0
True , i am also doing the same . but i like the new model experience it has more visibility when we writing any formula .0