Group tasks by individual project when linked to multiple projects

[Stuart_Muller]

Novice user here - I followed the videos and referenced some templates to build out a project management base with a linked tables for Projects and Tasks.

We have several Projects that comprise the same set of tasks but are different projects (applied to different subjects).

When I group tasks by project in a view of my Tasks table, I want to see them grouped by individual project. Currently, grouping tasks by project seems to treat every unique group of projects with the same set of tasks as “the project.”

The intention of this view is to see all the tasks for each project as rows grouped by individual project. As it stands, I cannot even tell which projects are grouped together in the tasks view without widening the field to preposterous levels (see figs below) because the grouped-by field has a fixed height.

Figures below show two groupings of tasks that differ by one project. I widened the field to be able to see all the project names and it is two monitors wide - first figure is the LHS screengrab and second figure is the remainder of the view after scrolling to the RHS.

[Kamille_Parks]

As of today, the “group” feature of Views treats the values of array-type fields (multiselect and record links) as one long string. It is not yet possible to have one group per array item, with records appearing multiple times in the view depending on how many individual groups they fall under.

While Airtable has talked about this possibly being changed in the future, no timeline for this change was given.

[Stuart_Muller]

Thank you - that’s illuminating.

Are there any suggested workarounds or best practices to manage this?

This seems like a pretty basic function of the suggested project tracker setup. How do users track tasks by project when the tasks apply to multiple projects?

[Hannah_Wiginton]

Yeah, it is unfortunate.

When I was newer to Airtable (2017), I posted a similar question

How to Group Multi-Select or Linked Record differently? Ask the community

How do I Group the multi-select field or the Linked filed to where it will show only one option vs Grouping the 2 or 3 I have in the original record? I am tracking my Daughters Daily Symptoms, mood, meds, etc. Here I am grouping the Symptoms. How do I only show the 1 Symptom vs showing all 3 from that day? Maybe I have this setup wrong for what I’m trying to do. [image] Any thoughts? Thank you!

A workaround would be to create multiple views filtered to display each individual active project

The filter would be something like Where Project Name “contains” Project A.