=LISTINDEX
The =LISTINDEX() function accepts a semicolon-separated text list and returns the list entry at the specified list index. (ProcessPlan uses semicolons as its list delimiter.)
Syntax
Section titled “Syntax”=LISTINDEX(ReturnIndex; SemicolonSeparatedTextList)Parameters
Section titled “Parameters”-
ReturnIndex
The position of the item to return from the list. Index numbering starts at 1. -
SemicolonSeparatedTextList
The semicolon-separated list of values to retrieve the item from.
How It Works
Section titled “How It Works”-
Reads the list as a sequence of values separated by semicolons
-
Uses one-based indexing to locate the requested item
-
Returns the value at the specified index
-
Works with both static lists and field tokens
Usage Notes
Section titled “Usage Notes”-
Index numbering starts at 1 (not 0)
-
If the index does not exist, the function returns an empty value
-
Formula functions are case sensitive and must be in ALL CAPS
Example
Section titled “Example”=LISTINDEX(2; ListEntry1; ListEntry2; ListEntry3; ListEntry4)Returns: ListEntry2
Keywords
Section titled “Keywords”LISTINDEX, list index, semicolon list, list item retrieval, text functions, formula function, calculated value