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

    Customize Sort Order Using Colours

    pademo57

      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?