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 information? π | 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 information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
Check out the Formula Handbook template!