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
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives