Choose
Returns the value with the corresponding index position. When an index number is provided and a corresponding value does not exist, a Null result is returned.
Usage
Choose(index number, value 1, ...)
index number (required) The index number of the value returned. Index value needs to be a number, a formula or column that references a number.
value 1 (required) The values from which to choose. At least one value must be provided.
value 2+ (optional) Additional values are optional.
Example
Choose(1, "value 1", "value 2", "value 3")
- Returns value 1.
Choose(Weekday([Date]), "Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday")
- Returns the name of the day of the week falling on the date in the [Date] column.