Hello all,
I am trying to make a spreadsheet that tracks employee fitness reimbursement balances based off of their entries into a form. Each employee has exactly $300 that they can use per year for fitness expenses. Every time they submit a reimbursement, it gets put into a form that includes their name, clock ID, date, expense type, and expense amount. I would like to start a new spreadsheet that tracks employee reimbursement balances based on the entries from the original form.
The trick part for me is that we do not have a list that includes all employees names or ID's, so it would need to pull this from the original spreadsheet and then calculate balances, even if they have multiple entries.