Hello! I have what I imagine is a pretty common set-up. I have 2 tables in my base:
Projects includes things like name, start date, end date, complete (checkbox).
When I create a new project, I have a multi-select option to assign many staff to the project. My issue is this - I would like to view all the projects that each staff member is working on in one list (or a Gantt chart, but the same problem arises). Seems simple, but I’m running into two issues:
1 - In the Projects table, I cannot group by Staff because it groups them both as individuals and when they are in groups together.
2 - In the Staff table, it pulls over all projects that have been assigned to them, not just Active Projects.
I have also explored creating a 3rd table to track Assignments separately, but that did not solve the issue either. But I’m open to that if that’s a better option.
Seems simple, but I cannot find a way around it. I look forward to any suggestions - thanks!