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?
Help Article Resources
Check out the Formula Handbook template!