Duration Column is not calculating property when a task has subtask
I am trying to calculate duration required for a task which has couple of subtask . Unfortunatly greatest value of subtask duration is shown in task duration (0.5d) instead of adding duration of all subtask . Estimated hours caluculated by formula doesnt match with Duration.. any idea how to fix .ss attached
Answers
-
Hello @Varinder
When dependencies are enabled, "the Duration on the parent reflects the number of working days between the parent row's Start Date and End Date. Instead of a sum of their durations, it provides a full-time span from the start of the earliest subtask to the end of the latest subtask.".
You might need to disable dependencies and manually add duration and create a sum formula in the parent row to be able to calculate based on your preference.
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
Thanks @Melissa Yamada . Can you help me to provide formula to calculate end date based on combination of estimated hours + start date for child subtask and main task . I already using formula to calculate estimated hours using =SUM(CHILDREN()) .
-
How about create a helper column that will change duration from hours to days?
Helper column (Duration (days)):=IF(Duration@row < 24, 0, IF(Duration@row > 24, Duration@row / 24))
Then on your End Date:
=[Start Date]@row + [Duration (Days)]@row
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!