@Select (Formula Language)

Returns the value that appears in the number position. If the number is greater than the number of values, @Select returns the last value in the list. If the value in the number position is a list, returns the entire list contained within the value.


@Select( number ; values )



Number. The position of the value you want to retrieve.


Any number of values, separated by semicolons. A value may be a number, text, time-date, or a number list, text list, or time-date list.


  1. This example returns 3.
  2. This example returns 3.
  3. This example returns Apr;May;Jun.
  4. This example returns San Diego;Sydney;New York;Amsterdam if the field named TrainingCenters contains these city names.