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?