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? – Ganesh Sanap May 5 at 7:56
  • It is a single line of text – fonsi May 5 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. – Ganesh Sanap May 5 at 8:47

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, privacy policy and cookie policy

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