Is it possible to sort by color?

Is there a way to sort the URGENCY column so the rows with the colored cells are at the top? Specifically, I’d want red at the very top and orange beneath it.

1 Like

Idea 1: It looks like the colour is based on the previous column (conditional formatting). Could you sort by that instead?

Idea 2: If you’re using conditional formatting for the colour, could you get it to also add a number (i.e. 1-5) in the field as well and then make the font the colour of the field so it’s basically invisible? Then sort by the number.

Idea 3: If it’s a choice list, there is a checkbox that lets you use the order of the choices when sorting.

1 Like