Flexible Duration value when calculating scheduling dates
I have a Smartsheet which is a project plan with the Dependencies and Duration columns is being used in scheduling calculations to automatically deriving the start/end dates for each task. However, I need the Duration to be dynamic e.g. linking cell to a cell in another sheet or to contain a formulae.. However, I cannot see anyway of achieving this - any suggestions on how to get around this?
Best Answer
-
Hi @Mark Duddy
If you're using dependencies in a Project Sheet, then the Duration column is not able to be updated via formulas or cell links. This is because it's used in combination with the Start and Finish dates in your sheet to automatically generate data (e.g. if you add the Start date and a Duration, the Finish date populates. If you add the Start date and Finish date, the Duration automatically populates).
You could set up your sheet to use regular columns and use your own formulas to generate automatic dates based on a text/number "duration" column, but then these details would not be associated with Critical paths or other Project features in a Gantt chart.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
@Mark Duddy This can be done, but requires an additional add-on. If you're interested, I can tell you more about this option. Send a message to me at https://www.smartsheetguru.com/contact/
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Hi @Mark Duddy
If you're using dependencies in a Project Sheet, then the Duration column is not able to be updated via formulas or cell links. This is because it's used in combination with the Start and Finish dates in your sheet to automatically generate data (e.g. if you add the Start date and a Duration, the Finish date populates. If you add the Start date and Finish date, the Duration automatically populates).
You could set up your sheet to use regular columns and use your own formulas to generate automatic dates based on a text/number "duration" column, but then these details would not be associated with Critical paths or other Project features in a Gantt chart.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!