Hi, All
I am struggling with retrieving a display name of a numbered list in a Property.
My understanding is that Name(Product) will retrieve #1, #2,,, in my case.
Could you give me some pointers ?
Thanks in advance.
Greg
@gregoryTan ,
As @VIGNESH.M stated, you can reference the Display Name of the Product numbered list. So if the numbered list for Product is Product Flat and if the display name of Product Flat is text, then the formula would be PIC &"_"&'Product Flat'.Display Name[Lookup:Product] as long as Product is list formatted. If it is not a list formatted, you will have to have the Product code accessible (in this list or preferably a module). This is another reason why having codes are so important, especially when using numbered lists.
Rob
Hi Greg,
Pick the Display Name from List Property directly. Don't use Name(Item(Product)), it will return #1,#2.
Regards,
Vignesh M
Just to add some.
I would like to have the column F in the attached file for a display name of this list (concatenate "Product" + "PIC"). But the problem is since "Product" is a numbered list, I cannot have "Product" in TEXT format while I need to convert "Product" into TEXT to concatenate "Product" and "PIC"
HI @gregoryTan,
In this case use lookup and bring in the Display name.
Ex: Product list.Display name[lookup:Product] where Product list is a list and Display Name is a property in that list and Product is the product list formatted property in your destination list.
I hope this helps!
Kavin.
Thank you, Rob. What youve proposed perfectly worked for me.
I recently ran into the same issue and came across this thread looking for a solution. What you proposed worked perfectly for me as well, Rob. Thanks for sharing!
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
