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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives