Function INDEXOFLIST()

 

Description
Returns the zero-based index of the assigned label in a list attribute for the current item.

 

Syntax

INDEXOFLIST(listName)

Parameters

• listName – Code name of the list attribute (must be quoted)

Return Value
NUMBER (index or -1)

 

Examples

Formula

INDEXOFLIST("mylist")

Result
2 (if assigned "High")

Formula

INDEXOFLIST("mylist")

Result
1 (if assigned "Med")

Formula

INDEXOFLIST("mylist")

Result
-1 (if no value assigned)

Notes (if needed)

• Must use quotes for listName
• Zero-based index
• Returns -1 if not found or unassigned
• Useful for ranking and conditional logic