Sort Order of a Column from another column in the same table

[John Klein]

It would be great if there was a way to specify the order of a Text column from another numeric sortorder column. Can anyone tell me how to do this. The apply sort order from column on the Sort Order tab makes no sense at all.

Thanks in advance.

John

[Kirsten Smith (she/her)]

The Apply Sort Order option only works on String columns based on other String columns. From the Help files:

 

 

Apply sort order from column

[The options below are only applicable to String columns.]

To be able to apply a sort order from another column, there must be some matching values in the two columns. If the column with the sort order you want to apply for example contains months, the column you want to sort must contain some of the months. This means that you cannot use a column with months sorted alphabetically to sort a column with names alphabetically.