How do you make duration dependent on a fixed end date?
I've created a new project where I will track the completion of grant applications. Each grant has a fixed end date (this will never change). However, if I use the dependencies tool to adjust the duration or start date accordingly, it often alters the end date instead. Is it possible to fix the end date and only have the duration and start date as variables?
Answers
-
I love to build from scratch but sometimes it helps to get ideas from a Smartsheet template. Take a look at this one:
Dependencies are there to help associate one task/row with another, and the two date columns work hand-in-hand with the duration column to convey the length of time that one task/row takes to implement.
The grant's fixed deadline is something else, normally included somewhere in the course of tasks/rows as THE milestone to reach, with a 0 in its Duration cell. It's often also highlighted at the top of the sheet, see screenshot example.
Does this help?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives