I�m using the new calendar report which is available on request now via support and will be rolled out, I think, in February to all users. It is the new type which has a Day, week and monthly view like Outlook and other calendar programs use.
It seems to sort fine and I also am using a formula like yours to concatenate and color fields.
The monthly view seems to sort by the field I am using to base the calendar on, which is a date/time field which is a formula of the date and time of the meeting combined into a Date/time formula field.
I�m assuming that you are on the old ( current) calendar and not the advance access new calendar. So I suggest that you get in the new calendar and stop messing the nuance of the color issue on the old calendar , because in a month for two you will likely lose access to the inferior calendar anyways.
