Dynamic dates
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?
Comments
-
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 -
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
