Dynamic Durations

edited 12/09/19 in Smartsheet Basics

I would like to calculate the duration based on two tasks.  For example, I want a start date from say task 1 to be the start date of Task 2, while the end date of Task 2, to be the start day of task 100.  The duration should of Task 2 will now be the total number of days between task 1 and task 100.  If I adjust Task 1 or Task 100 then Task 2 duration should also update.


Any ideas?


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    Smartsheets doesn't let you create flex dates. Meaning, you can have a task start or end be based on a predecessor, not both. I've tried unsuccessfully to tie a start date to a predecessor and the finish date to another row. This is currently not possible at this time.