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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!