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.
Half Day - Vacation Days?
Comments
-
I built an Attendance sheet to show Gantt and Calendar views. I built a Web Form that our staff uses to request their PTO or travel. If they are going to be gone less than a full day I have them enter the time in the duration field such as 4h for four hours. This seems to work fine.
-
If you are using resource management, set allocation to 50% (half day)
-
Late response but when searching for a solution this was near the top of the google results.
I simply added an additional checkbox column called 'Half Day' and then adjusted the formula in the 'Holiday Days' column by wrapping an IF statement around the existing formula to make it the following (row numbers removed);
=IF([Half Day], NETWORKDAYS([Start Date], [End Date]) * 0.5, NETWORKDAYS([Start Date], [End Date]))
The only minor issue with this is that if someone takes a half day within a bigger block of holiday (i.e. 2.5 days etc.) then they will have to split onto separate rows.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 494 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives