Hello I have these four pieces of data:
Project Name {Text Field, Primary Field}
Project Start {Date}
Project End {Date}
Project Team (multiple people) {???} *can be separate table
I want to be able to create these views:
a gantt view for my projects
This will show the project name and the start and end dates
a gantt view for each individual team member
This will show each project they are working on
My team will consist of four individuals that will be working each project. Some projects will have all 4, others will only have a couple. I need to be able to see how many projects each person is working on and how long they will be busy with projects.
For the Project Team data I’ve tried linked records, collaborators, and mult-selects but they aren’t being treated as individuals, they are being treated as a group in all the versions of the gantt I’ve tried.