Half day vacations
Hello,
I built a form for my department to request and track their vacation days. The standard data includes date of request, start date and end date, as well as, adjustment days to exclude holidays from their remaining allocated vacation days. However, some are asking for half days, I put a checkbox in the formula but how would I build a formula for that? Is there an alternative option?
Also, how would I add it in the vacation days remaining column? My current vacation days remaining formula is [Vacation Days Allotted 2022]@row + [2021 Carry-Over Days]@row + [Pay in lieu of PTO]@row - [Vacation Days Used]@row.
Thanks
Best Answer
-
You can change the Vacation Day row to a number entry instead of check box and use 0.5 for half day.
...
Answers
-
You can change the Vacation Day row to a number entry instead of check box and use 0.5 for half day.
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!