How to get the Index of a Numbered List Item ?

Livy
New Contributor

How to get the Index of a Numbered List Item ?

Hi guys

 

as the subject, I want to get the Index of a Numbered List Item, what attribute/property should I use?

 

the Propeties I've tried:

(Item )Index

(Item )ID

(Item )Number

(Item )suffix

 

by the way, what is the data type of the index?

 

Thank you~

1 ACCEPTED SOLUTION

Accepted Solutions
M.Kierepka
Certified Master Anaplanner

Re: How to get the Index of a Numbered List Item ?

Hi,
Dimension a line item only by "Your list". Then:
If you want it as text: MID(NAME(ITEM('Your list')), 2, 10)
If you want it as number: VALUE(MID(NAME(ITEM('Your list')), 2, 10))

View solution in original post

2 REPLIES 2
Misbah
Moderator

Re: How to get the Index of a Numbered List Item ?

@Livy 

 

You can use NAME function to get the #ID's of Numbered list

M.Kierepka
Certified Master Anaplanner

Re: How to get the Index of a Numbered List Item ?

Hi,
Dimension a line item only by "Your list". Then:
If you want it as text: MID(NAME(ITEM('Your list')), 2, 10)
If you want it as number: VALUE(MID(NAME(ITEM('Your list')), 2, 10))

View solution in original post