Retrieve Numbered list' Display Name

Options
gregoryTan
gregoryTan Member, ALL USERS, Community Member Posts: 5 Contributor

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

Comments

  • gregoryTan
    gregoryTan Member, ALL USERS, Community Member Posts: 5 Contributor

    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"

  • gregoryTan
    gregoryTan Member, ALL USERS, Community Member Posts: 5 Contributor

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