auto populate due dates

Dion Chapman

I want task due dates to auto populate based on one date that I enter as the event date. For example, I will set an event date and certain tasks will be due 2 weeks prior to event date. When I create individual event sheets, I want to enter that event date and then due dates will auto populate for each event based on that date.

Jeremy Myers

=WORKDAY([Start Date]1, -14)

J. Craig Williams

Dion,

 

If you project settings have Dependencies enabled, use Predecessors.

Sounds like you want to work backwards from the end date, so use something like this:

 

https://www.smartsheet.com/blog/support-tip-work-back-schedule

 

Craig