Task Dependency

Jameel Nahas · 09/27/20

Hi Team ,

As part of Program of Work sheet for a project , i have created a task which is a collection is set of sub tasks that can be completed if only the subtasks has been completed .However ,i am facing this issue where in my end task completion date gets auto filled as even if the only one of the sub task activity is completed .Please advise how this can be rectified :

For Example Below

COLUMN 3 AND 4 : Planned Start Date and Planned End Date

COLUMN 5 AND 6 : Actual Start Date and Actual End Date

The Coloum 6 Of the Main Task shouldnt be populated until the 2 sub task has a value/Date in Column 6

Hope i can have assistance to the below .

Regards

JN

David Joyeuse · 09/27/20

Hi @Jameel Nahas

Just guessing here as I don't know how your project works as a whole, but there's no duration in the 2nd subtask. Duration for Kitchen is 3 days, which is Data and CCTV Cabling duration, so for your project that probably means that the task is done.

If it isn't the cause of it, could you share the formulas in your dates column please?

Hope it helped!

David Joyeuse · 09/27/20

Hi @Jameel Nahas

Just guessing here as I don't know how your project works as a whole, but there's no duration in the 2nd subtask. Duration for Kitchen is 3 days, which is Data and CCTV Cabling duration, so for your project that probably means that the task is done.

If it isn't the cause of it, could you share the formulas in your dates column please?

Hope it helped!

Jameel Nahas · 09/28/20

Hi @David Joyeuse

I had the dependencies parameter set incorrectly .The formula now works as it intends.Thank you very much

However my main tasks reflects the status as completed ,though all my subtask are not completed ,and due to this task completion status is not true .How can we make sure that the Main task end date is populated /updated only once all the sub tasks is completed .Image below as reference