Duration Column with Dependencies Enabled
Hi All,
So with the duration column, we have decided to enable the dependencies however the calculation seems a bit off
To test it we but in 2 days for duration
Dependency is Start Date and Due Date
We thought that if the Duration is two days. We put in a Start Date of 9/1/2020, then the Due Date should be 9/3/2020. Instead it is as if Smartsheet counts the date entered as a whole day when the day should begin the next full day.
Any tips or feedback is greatly appreciated!!!
Best Answer
-
Your start date is considered one of those days, so the 1st 8 hours (1 day) is the actual start date.
So 16 hours = 2 days.
Day 1 = 09/07/20
Day 2 = 09/08/20
24 hours is 3 working days.
Day 1 = 09/07/20
Day 2 = 09/08/20
Day 3 = 09/09/20
Based on your screenshots, the dates are accurate, but based on your explanations you are actually wanting to start the day after the date in your start date column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Hi @Leslye Jackson,
why don't you enter the actual start date?
Start date is a full 8 (or whatever) hour working day. So if you say the task takes 2 d, that's 16h in your settings and this results very correct in the two days 1. + 2. of September being used.
Hope this helps
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
@Stefan Thank you for your feedback so I tried that but it literally didn't change the results. I put in 24 hrs and it counted two days.
-
Your start date is considered one of those days, so the 1st 8 hours (1 day) is the actual start date.
So 16 hours = 2 days.
Day 1 = 09/07/20
Day 2 = 09/08/20
24 hours is 3 working days.
Day 1 = 09/07/20
Day 2 = 09/08/20
Day 3 = 09/09/20
Based on your screenshots, the dates are accurate, but based on your explanations you are actually wanting to start the day after the date in your start date column.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you so much for your feedback on this!! All of you guys rock!!!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @Leslye Jackson ,
also happy to help!
As @Paul Newcome already pointed out, the dates your sheet shows are correct.
The connection between the figures in DURATION and the start/end date is determined by the section "Working days" in your project settings. Everything you change there influences the calculation of the end date.
For a deeper understanding you may check these articles:
Greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives