Hello,
What formula should I use for the code line item? Instructions did not specifically describe the code.
Thank you in advance!
Oh, so close @JeemarieB - I should have been more precise. When I wrote "list" you need to put the list you want to address. So it will look close to this, all depends on what you named the list. CODE(ITEM('P3 SKU'))
Notice that when you have any characters that are not alpha numeric, like the number "3", you will have to put the list in single quotes like'P3 SKU'
See if that helps.
@JeemarieB
You can use the CODE function which will return a text formatted value. So, CODE(ITEM(List)). If done correctly will look like these codes here.
Hi Jared,
Formula is invalid on my end. Is there something I'm doing wrong here?
It worked! However,I noticed that the font for the codes changed from blue to black. Is this how it's supposed to be?
Astute observation! Yes, when you enter a formula the font will be black as an indication that the cell will not be editable. Anytime you see a blue font, the cell is editable. Good job! You're quickly becoming an Anaplan Champion.
Gotcha! Thank you so much for you help!
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!
