Apply non-working days of individuals to project plan
I'd like to allocate non-working days for individuals tasked with deliverables on my project plan. I have two Smartsheets:
- Sheet 1 = A project plan - showing all allocated resources against multiple deliverables.
- Sheet 2 = A Vacation Planner - showing all team members involved in the project and the days they are on vacation or non-working.
How can i connect the two sheets so that the Duration of each deliverable assigned to that project team member and the Planned Start Date and Planned End Date for that deliverable (in Sheet 1) changes according to the project team member's annual leave schedule (in Sheet 2)?
Tags:
Comments
-
This cannot be done within Smartsheet without disabling the dependencies which from the sound of things would have a major impact on your current setup.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!