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 .
Help Article Resources
Check out the Formula Handbook template!