2 Replies Latest reply on Mar 18, 2017 6:09 AM by pademo57

    Customize Sort Order Using Colours


      I'm sure there is an easy solution to this but for the life of me I haven't been able to figure it out.


      I have a category field which uses 3 colours: Green, Yellow and Red, which represent how critical a job is.


      I would like to sort it showing:


      Red, Yellow and then Green. But when I try to sort it, the sort order shows Yellow, Red, Green. Which I understand is alphabetical.


      Can someone show me how to make this work please?