Gantt Chart - linking start / end dates

NHaines

Im a beginner so bare with me.

Im creating a GC where the beginning and end part of the process are irrelevant for the C suite - only interested in hard deadlines and the overall duration of the project minus the grey areas. However, these task rows and durations need to still be included to help manage the work flow for teams involved.

How to I link the over all start and end date to specific rows without deleting the greyed out row. See attachment. ive played with predecessors etc but cant figure it out.

Thank you for your help.

AravindGP

Hi @NHaines

You can add a helper column in your sheet and make it a checkbox. You can manually check this column for items to be included in the date calculation for your management. You can then add another column/Sheet Summary column to use a formula as below to get the start and end date for your management.

=MIN(COLLECT(Start:Start, [Included?]:[Included?], 0))

=MAX(COLLECT(Finish:Finish, [Included?]:[Included?], 0))

I have named the first column as "Included?"

In the above example, I have created two new columns (Mgmt Start and Mgmt End) to get the dates using formulas.