Differentiate sections in master gantt chart with different colors to show different projects
I created a master gantt chart where the beginning and end dates are linked of different projects within one branch of the business. So each line would have columns like the below with the gantt chart to follow.
Project 1 | 60 days | 3/1/21 | 6/1/21
Project 2 | 120 days | 3/1/21 | 9/1/21
Is it possible to show a particular phase on the gantt chat that happens on the linked sheet? As an example, during the middle of every job it has to get inspected, I'd like to show when the inspection is expected to be on the master gantt within the same row as the beginning and ends dates. Ideally the bar would be one color, but the inspection timing within the bar would be another color.
Help Article Resources
Check out the Formula Handbook template!