How to use the INDEX operation to set up conditional formulas in formulas
Definition
The INDEX operation returns the element at a specified position within a list.
Example
INDEX($ATT.list, 1)
$ATT.list = ["Apple", "Banana", "Cherry", "Date"]
Result:
"Apple"
Syntax Guide
INDEX(list, index)
- list: The list from which to retrieve the element.
- index: The position of the desired element in the list.
Formulas In Use
⚠️ For a list example: ["Apple", "Banana"], using INDEX($ATT.list, 5) will return an empty value, as the index exceeds the list size, in this example, 2.
Using INDEX($ATT.list, 1) on an empty list will return an empty value.
What's Next
- Learn more about how to write formulas
- Check out the IFBLANK operation
- Check out the IFNULL operation
If you have any questions, just click on the chat box in the bottom-right corner and we'll be happy to answer them...