How to group by individual field (employee)

[Kevin_Moreau]

Hi All,

I am working on a work report / timesheet integration in Airtable. I currently have multiple tables
Tasks
Projects
Workers
Clients

In the tasks table I will write in different columns the following:
Task description
Type of task
Project Number (from the projet table)
Date
regular time
Overtime
Employee (from the workers table)

I would like to be able to group the tasks by employees. There will be multiple employees working on the same task and currently the grouping will group all the employees together instead of individually. Is it possible to get the grouping to group each employees individually regardless of who worked with them on each of the tasks?

[Kevin_Moreau]

Anyone has a solution to group a multi-select field individually?

[ScottWorld]

You can’t group a multi-select field individually. You would need to convert your multi-select field into a linked record field instead, and then go into the OTHER table to sort your records there.