Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
auto populate due dates
Options
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.
Comments
-
=WORKDAY([Start Date]1, -14)
-
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
This discussion has been closed.