SORT
Sorts the specified list using an optional sort order and expression to control the ordering.
Syntax
=SORT(array)
=SORT(array, order)
=SORT(array, order, expression)
Arguments
| Argument | Type | Description |
|---|---|---|
| array | Array | The array to sort |
| order | String | (Optional) Ascending or descending order. Should be one of "ASC" or "DESC" |
| expression | Any | (Optional) An expression that, when evaluated, is used to sort the array |
Examples
=SORT(ARRAY(3, 1, 2, 4, 0)) → [0, 1, 2, 3, 4]
Sorts the array in ascending order based on value.
=SORT(children, "ASC") → [Shape 1, Shape 2, Shape 3, Shape 4, Shape 5]
Sorts the list of children of the current shapes in ascending order, sorted by each child's text.
=SORT(children, "DESC", this."Property 1") → [Shape 5, Shape 4, Shape 2, Shape 3, Shape 1]
Sorts the list of children of the current shapes in descending order, sorted by each child's shape data property "Property 1".
Updated 9 months ago