AnsweredAssumed Answered

Customize Sort Order Using Colours

Question asked by pademo57 on Mar 17, 2017
Latest reply on Mar 18, 2017 by 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?

Outcomes