Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Keeping a running balance, based on a unique identifier

Hello!

I am trying to figure out how to create a tracking sheet for employee Tuition reimbursements.

We allow an Annual Funding Maximum, and each time the employee submits a request, I'd like a formula to show their current available balance, based on their annual maximum. We have employee ID's as a unique identifier.

The catch is that each employee might have a different Annual Maximum amount. I am not sure how or if this is possible.

I'll attach an image of my test sheet to show what I am looking for, but I am sure it won't be this simple.

Capture.PNG


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions