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?

Crystal Macklin
edited 12/09/19 in Archived 2016 Posts

hi, I am using the smartsheet vaction tracker as well. Has anyone figured out how to track half days? 

thanks in advance.


  • Stan Adell

    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.

  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    If you are using resource management, set allocation to 50% (half day)

  • Phil Adams

    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.



This discussion has been closed.