How can I order based on a specific sequence? In my view I have the following items: - X1 - X2 - X17

The order in the view is being displayed as: - X1 - X17 - X2

How can I force the first type of sequence?

enter image description here

  • What is the column type of Section field? May 5, 2019 at 7:56
  • It is a single line of text
    – fonsi
    May 5, 2019 at 7:58
  • 2
    Then you cannot sort on single line of text like you wanted... However you can add one more number field "order" and sort on that column. May 5, 2019 at 8:47

1 Answer 1


Add leading zeros: X01-05, X01-12, X02-01, X17-01

If you don't want to change the data, add a calculated column that inserts the leading zeros and sort on it, but don't display it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.