Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Calculate Employee Sick/Vacation time

1113 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Student_Service
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi All, I have a great working time sheet base that calculates day totals and accrued vacation and sick time, but now I want to be able to subtract USED vacation and sick time from those accruals. I’m wondering if I can use check boxes to identify entries that are sick or vacation and the work those checked boxes into a formula that subtracts the identified records from the total accrued.

Here’s a screenshot:
Screen Shot 2020-11-04 at 4.37.09 PM

Thanks for any help you’ve got!
Heather

1 Reply 1
Galia_Davimes
4 - Data Explorer
4 - Data Explorer

Hello,

I am looking for a time sheet base that does exactly that. Would you mind sharing that base? I am not so good with formulas and have been trying to create this for 2 days now :cry: :grinning_face_with_sweat:

Any help would be so appreciated!

Best,
Galia