Running Balances for employees

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!