Hi,

I think i got a tough one.

I'm and trying to make a painting schedule. It will get a list of orders. Each order has a colour.

I need to have a report that list orders by days of week, by colour. weekdays have preset certain colours.


Make a formula of days of the week, then custom sort orders? Cant seem group or sort by formulas.

Anyone got ideas to do this?