How can I spread a duration across days to get an end date that is different than just 8 hours per?
Hi...I want to be able to have my duration and end date be independent. For example, if I have a task that starts on 11/1 and will take 16 man-hours but we are going to spread those man-hours across 4 days (4 hours per), I want my end date to be 11/5. Automatically, when I put in 16 hour duration, I get 11/3. If I change the end date to 11/5, it bumps up my duration to 32 hours. Neither of those is correct. I want 16 hours starting on 11/1 but with an end date of 11/5. Is that possible?
Answers
-
Hi @ndgrad95
If you know your entire Project Sheet will always have a set timeframe of 4/hrs per work day, then you can apply this work schedule to the sheet by adjusting the Project Settings.
However if you are only wanting to adjust the working hours for those specific days, you will want to create a hierarchy with the Parent task being the overall task and each Child Row beneath represents one day of 4hrs work, like so:
The Parent Task will show the earliest Start Date of the Child rows and the Latest End Date of the Child Rows, with the total duration of 4.5 days, whereas each child will identify the number of hours per-day. See: Parent Rollup Functionality
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives