Date Formula Automation


I am trying to auto generate a start and end date for each task in a project tracker. I want the start date of the new task to look at the prior task, add the number of days to complete and then calculate the nest start date (and end date) of the task after it.

For example,

  1. Review Start 1/14/2022 End 1/15/2022 Duration 1d
  2. Design Start 1/16/2022 End 1/20/2022 Duration 4d

Is there a formula or way to do this?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!