Group data in a table view and sort the groups by another data

[ealwolf]

Hi!

I’m having trouble sorting my data in a table view.

I have a view called Tasks where it shows tasks assigned to certain people. It has some data, such as the name of the person, the task assigned, and the event in which the task should be done.

That event is a reference from another table, and it has a date and a name.

So in this Tasks view, I want to show the tasks grouped by event, but sorted by the date of the event. To explain it better I’ve attached an image.

I’d like these tasks to stay grouped by the event name, but also that these events were not sorted by their first letter, but from the date they were set to. What could be a workaround for this?

Thank you very much for your help!