nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Retrieve Numbered list' Display Name

gregoryTan

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

NumberedList_Display_50738.xlsx

Accepted answers

rob_marshall

@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

All comments

VIGNESH.M

Hi Greg,

Pick the Display Name from List Property directly. Don't use Name(Item(Product)), it will return #1,#2.

Regards,

Vignesh M

gregoryTan

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"

kavinkumar

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!

Regards,

Kavin.

rob_marshall

@gregoryTan ,

Rob

gregoryTan

Thank you, Rob. What youve proposed perfectly worked for me.

Steven_Barry

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!

Quick Links

Can you help?

Unanswered questions

L3 Sprint 2, User Story 3.3 Q1 Quarter Allocation
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
Looking for Anaplan End-Users to take a short survey!
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.…