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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!