|We have a workflow that is controlled and displayed by status of the job. Status is a text field stored as choices in a drop down.|
When I view active work, I want it grouped by status(easy) then the groupds sorted by the order they appear in the drop down.
2 work arounds, 1: include a number at the start of the status. 2, creates a relationship with a status table.
Either will work, and I'll go with 2 I bet, but it would be a nice feature to make it more simple.