Skip to main content
Skip table of contents

Stringfunctions+ | Formula SORTBYLIST

Description

This formula sorts a list of values.

Formula(s)

PHP
{=SORTBYLIST(List;Sort list;Sort direction;Sort type)}

Result

  • Array

Parameters

Parameter
Content
Format
Default value
Explanation

List

Array to be sorted

Array

 

 

Sort list

 

Array

 

 

Sort direction

Ascending or descending

Integer

SORT_ORDER_ASC

Possible values:

  • SORT_ORDER_ASC

  • SORT_ORDER_DESC

Sort type

Natural, alphanumeric, numeric

Integer

SORT_TYPE_NATURAL

Possible values:

  • SORT_TYPE_NATURAL

  • SORT_TYPE_STRING

  • SORT_TYPE_NUMERIC

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.