Calculating Remaining Eligible Vacation Days with already Approved / Declined Requests
Is it possible to do the following in SS?
I'm currently working with two sheets, Leave Requests and Employee Directory.
- My Leave Requests is the main sheet I'm working with - a running list of all leave requests from our staff
- My Employee Directory is a reference sheet for the number of annual vacation days an employee is eligible based on their length of service at our company
In my Leave Requests sheet, I have two scenarios, based on three statuses that I currently have on my sheet: Approved, Declined, Submitted
- If a leave request is Approved / Declined, and the employee already has existing requests on my sheet (regardless of status), I want to take the annual number of vacation days (from my Employee Directory) sheet, and minus all the already approved vacation days to calculate the employees' remaining vacation days
- If a leave request is Submitted, leave my remaining vacation days blank until it is Approved / Declined, then use calculation from Scenario 1
Does my explanation above make sense?
If this is possible, perhaps someone can help me out with the formula? I'm struggling with determining how to add all the already approved vacation days for a specific individual.