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.
Holidays incorporated into schedule

hi does anyone know how to put a holiday into the schedule so when you are creating schedules it will automatically account/not account for those days? i know it can be done i just can't remember how. thanks
Comments
-
In the gantt chart view click the Project Settings icon at the top left, make sure dependencies are enabled and then you can edit working days. This will edit for the sheet.
If you need to change it account wide, go to the Account Icon(Top of page), under Account Admin...., Acount Settings....Edit Working Days.
-
WORKDAY(): Returns a date that is the specified number of working days before or after a date.
Example: =WORKDAY([Due Date]5, 6)
Result: 3/10/14 (US date format)
You can designate other dates as non-working to exclude them when calculating the new date. To do this, enter each holiday/non-working day into a cell and then reference the range of cells in your WORKDAY formula.
Syntax: WORKDAY(start, num_of_days, holiday:holiday)
Example: =WORKDAY([Due Date]1, 365, [Due Date]2:[Due Date]3)
Result: 3/30/15 (US date format)
-
perfec thanks
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives