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.
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.
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:
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.