If I create a custom field that is a drop down, with a short list of values, and then sort my cases on that field in the list view, the cases are sorted by the values of that field in alphabetical order. Is it possible to sort the cases so they are in the same order as the values in the dropdown?
eg, a Severity field with values Critical, Severe, Important and Trivial, specified in that order in the dropdown, will sort Critical, Important, Severe, Trivial in the list view.
Short of prefixing the values with 1, 2, ... is there a solution?