Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 23, 2022 11:50 AM
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.
Solved! Go to Solution.
Aug 25, 2022 10:26 AM
I consulted a coworker and she was able to show me how to use a timeline view to achieve what I needed. For whatever reason Timelines allow “split multiple values” but gantt doesn’t.
Aug 23, 2022 07:13 PM
Hi @Jeremy_Abrahams , I think to achieve a gantt view for each individual team member you’re going to need a new table where each record contains the team member, project name, project start date and project end date I’m afraid.
Definitely not the answer you’re looking for I reckon, but I think it’s the only way
Projects table:
Projects by Team Member table:
Projects by Team Member gantt:
Aug 24, 2022 06:49 AM
Adam, thank you. I was afraid it would be something like this. Not sure AirTable is the correct tool then, unfortunately.
Aug 24, 2022 11:28 PM
Hmm, would it help if I told you we could automate the data updates to the Projects by Team Member
table?
That is to say, you would set up the Projects by Team Member
table’s layout and automations, and after that you would never touch it again, you would just refer to the Gantt view within that table
All your updates would be made to the Projects
table and would automatically sync up
Aug 25, 2022 10:26 AM
I consulted a coworker and she was able to show me how to use a timeline view to achieve what I needed. For whatever reason Timelines allow “split multiple values” but gantt doesn’t.
Mar 23, 2024 10:10 AM
This is an old thread, but the top hit for a related question I had. I think it would be easier having multiple gantt views, identically configured, but filter rows to those involving that target person/team etc.