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.
Vacation days formula; how to allow for halfdays (or holidays)
Not having a lot of background experience with formulas, I am having difficulty determining whether or not the NETWORKDAYS formula can be "adjusted" to include an allowance for halfdays.
Using the Vacation template, it calculates the number from start to end days. I have added a checkbox column for halfdays. If this box is checked, I want it to subtract .5 days from the 1 day total (created by the NETWORKDAYS formula). Clearly I am doing something wrong because the formula comes back as UNPARSEABLE.
Is it possible to create the formula noted above and, if so, where am I going wrong with the formula below?
=(NETWORKDAYS([Start Date]63, [End Date]63)  IF([Halfday]63, .5_if_true, 0_if_false))
Thanks in advance!
Comments

Pam,
You want your if statement first, try this using your column names:
=IF([Column38]11 = "True", NETWORKDAYS([Column36]11, [Column37]11)  0.5, NETWORKDAYS([Column36]11, [Column37]11))
Christine

That worked perfectly  thank you! (Not to mention the formula actually makes sense.)

Okay, one more. I have copied and adjusted that formula to perform a similar function when a holiday occurs within a vacation period (thereby subtracting 1 day from the total). Is it possible to add the two formulas together
=IF([Halfday]63 = "True", NETWORKDAYS([Start Date]63, [End Date]63)  0.5,NETWORKDAYS([Start Date]63, [End Date]63))
PLUS
=IF([Holiday amidst vacation]62 = "True", NETWORKDAYS([Start Date]62, [End Date]62)  1, NETWORKDAYS([Start Date]62, [End Date]62))
where the end result is NETWORKDAYS  .5 (for a halfday)  1 (for a holiday) [that could be minus 1.5 if both statements are TRUE), and minus 0 if both statements are FALSE?

You can use If(And(. Don't forget to write for if both are true and then if only one is true but not the other.

Thank you, Christine!

Wow, that one took me a while to work out. However, good news  I managed to finally figure it out, and it worked!
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.9K Get Help
 410 Global Discussions
 220 Industry Talk
 458 Announcements
 4.8K Ideas & Feature Requests
 143 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 298 Events
 37 Webinars
 7.3K Forum Archives