Dynamic dates

emma.street65896

Very new to this program so hopefully this is not a stupid question...

I need to set a sheet up where there are fixed times within a 4 week cycle for certain steps to occur. For instance we can only order a certain pack on Friday of week 1 of any 4 week cycle. Is there a way to set this up so if the predecessor finishes ie monday of week 2 it recognises it has to wait until the following Friday week 1 to complete this next step?

Is there such a thing as specific calender for one step?

Isaac Jose

Hello Emma,

Thanks for your post! It sounds like you're looking for a feature similar to the  Constraints feature from Microsoft Projects. Currently, Smartsheet doesn't support this feature, but you can submit a Product Enhancement Request using the quick link to the right.

If you want to set the Start Date of your task as the next Week 1 Friday following the end date of your Preceding task, you'll want to remove the predecessor and update the Start Date manually. I've included some related resources from our Learning Center below:

• Enable Dependencies and Use Predecessors https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
• Project Sheet Columns https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
• Project Management https://help.smartsheet.com/learning-track/smartsheet-advanced/project-management-tutorial

Kind regards,

Isaac J

Smartsheet Support

Jody Odom

This dynamic dates question is from 2018. Just checking to see if Smartsheets have since added dynamic dates. I have an immediate need to have all related dates update when I change the dates of of tasks and dependencies.

Example, Milestone 1 will be delayed by 1 week, so I update the due date to 1 week later. I need for the dependent dates of all impacted other milestones and tasks to be automatically updated.

Best,

Jody