Point Tracker System
Hello, I am wanting to build a system for tracking points. There are two kinds of points: good and bad. Simply put, I want to keep an up to date tracking for each employee. Here is what my starting base is:
Now here is where I am getting stuck. How do I make it so that I can reference a specific employee's total from a previous row? For example, in my chart, Steve was a bad boy on the 6th, so he gets minus 1 point which brings his total from 5 down to 4.
I am not opposed to creating helper sheets or columns. I'm just not sure what direction I should go in. Any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!