Gantt Dependencies while using Start, Due, and Complete

Derek Williams

Hola!

I need the “Start” and “Due” columns to be the active “Dependency Settings” to ensure the full schedule self populates during the initial schedule setup.

But, I need the “Complete” column to either override the [Due]@row date, or, reflect on the “Start” date while using predecessors, to update the schedule as items are actually complete.

Note: I also use a few functions and conditional formatting to alert me when the “Due” column is overdue.

My full project schedules have over 200 rows each, and I run about 60 projects at a time by myself. So basically, I need to use this setup to quickly populate task completion dates, with automatic schedule updates, without spending time revising my due columns, predecessor columns, or duration columns.

Any ideas? Anyone else have this Gantt issue?

I've racked my brain for 6 months, and have come up with no fix for this. Please be my hero!

-DW

Aravind GP

Hi Derek,

The dependency settings allows for setting up predecessors to calculate the next start date based on a dependent tasks' (planned) completion date. I understand that you are trying to add in another date column to capture the actual end dates and want the next dependent tasks' start date to start after the actual completion date (which I believe is manually entered).

Since the settings looks at only one column for end dates to calculate the next start date (based on the predecessors set), the better option will be to update the actual end date in the "Due" column as per your sheet. This way, the start gets updated using the dependencies settings.

If your objective for having a due column and complete column was to track variances in baselines vs actuals, it is a feature due to be released in the next update (possibly by January 2021).

Aravind GP

Hi Derek,

The dependency settings allows for setting up predecessors to calculate the next start date based on a dependent tasks' (planned) completion date. I understand that you are trying to add in another date column to capture the actual end dates and want the next dependent tasks' start date to start after the actual completion date (which I believe is manually entered).

Since the settings looks at only one column for end dates to calculate the next start date (based on the predecessors set), the better option will be to update the actual end date in the "Due" column as per your sheet. This way, the start gets updated using the dependencies settings.

If your objective for having a due column and complete column was to track variances in baselines vs actuals, it is a feature due to be released in the next update (possibly by January 2021).