Task table with multiple team members assigned - report individually

Hi! It’s my first post here, so please let me know if I missed the answer somewhere in the Community site.

I have built Project and Task tables. The Project table can only have 1 owner (collaborator). However, the task can be owned by a team of people (collaborators).

What I would like to see is a grid view which lists each collaborator and any task where they are tagged. When I run this, what shows up is something like this:

Ben
Task 1

Ben, Bob
Task 2

Ben, Bob, Shelly
Task 3

However, what I am trying to create is a user-unique view so it would look like this:

Ben
Task 1
Task 2
Task 3

Bob
Task 2
Task 3

Shelly
Task 3

I cannot figure out how to break this out so hoping an expert can come along and help me out.

Thanks in advance.
Ben

Hi @bjenkins,

Welcome to Airtable Community!

You can create a new table that is called Collaborators (or Employees), link the field with the names to this table, it will give you the info you need.

Please see attached base.

BR,
Mo

Thanks, @Mohamed_Swellam. I really appreciate quick follow-up!

That gets me closer, but I am struggling with the view I want to see. Using your table (thanks for creating example), I cannot figure a way to show a summary of all tasks associated with each user.

For example, if I group the ‘Table1’ tab, I get this:

image

However, that is aggregating the Collabs into a single line entry. Instead, I want to see something like this:

Ben
Task 1
Task 2
Task 3

Bob
Task 2
Task 3

Shelly
Task 3

The goal is to quickly see how many tasks are associated with each user regardless of whether they are working on a task solo or part of a team.

Any thoughts on that?
Ben

Ya that is not doable using views, the best way is to have another table like the one I sent you, this way you have 1 collab with multiple tasks.

Gotcha, @Mohamed_Swellam. I hoped that wasn’t the answer, but appreciate the confirmation.

Have a great day.
Ben

1 Like