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
- Smartsheet Customer Resources
- 62.4K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives