Is it possible to fix duration?
Hi, is it possible to fix duration so when I change the end date, the duration stay the same BUT start date is updated? See below, first picture is my starting point. Second picture is what happened when I change End date : duration is changing not the start date.
Thanks,
Best Answer
-
Currently Project sheets use the Start Date and Duration to then calculate the End Date. This means that the Duration is linked to the Start Date, but will adjust based on the End Date (as you've found).
In order to change the End Date but keep the Duration the same, you would actually need to change the Start Date. This will keep the Duration the same but push the end date to the new day. Does that make sense? You can read more about Project Settings in our Help Center (see here).
You may also want to submit an Enhancement Request to provide feedback to our Product Team if adjusting the Start Date doesn't work for your purposes.
Cheers!
Genevieve
Answers
-
Currently Project sheets use the Start Date and Duration to then calculate the End Date. This means that the Duration is linked to the Start Date, but will adjust based on the End Date (as you've found).
In order to change the End Date but keep the Duration the same, you would actually need to change the Start Date. This will keep the Duration the same but push the end date to the new day. Does that make sense? You can read more about Project Settings in our Help Center (see here).
You may also want to submit an Enhancement Request to provide feedback to our Product Team if adjusting the Start Date doesn't work for your purposes.
Cheers!
Genevieve
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!