Combined Gantt from two tables

1479 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi All, How do you produce a gantt chart which has the tasks from two different tables (in the same base) and shows the dependencies between them? ie you have two projects generally be tracked separately but want a gantt view of the dependencies between the projects? Thanks

1 Reply 1

Welcome to the community, @Xenia_Nealon! :grinning_face_with_big_eyes: I recommend reconsidering your base design. If the tasks are truly related, it’s best to put them all into a single table. You could then use something like a single select field—or a link field to a [Projects] table—to identify which project each task is tied to. To see each project’s tasks separately, create custom views that each filter based on a single project. With all tasks in one table, a single Gantt chart could be created that shows the relationship between all tasks across both projects.