I am looking for two things that would really be accomplished with the same solution.
#1. Tracking inventory in real-time
#2. Tracking how many PTO hours employees have left
I would like some way to just enter “1” or enter “24” into a column and it auto updates another column to be a real time number.
for ex for #1. (inventory)
we have a bunch of uniforms. When I give out 1x Safety shirt (or 5) I would like my “total” to reflect my total without having to manually go in and change the total.
—click a button and it subtracts 1 every click
—enter “amount given that day” into another column and it keeps subtracting (not from a cumulative total like ex #2 below)
ex for #2. (PTO)
Each time an employee uses PTO I would like to type into a column how many PTO hours they used and then the “Total left” column would update to the correct amount.
^^ I have a board set up for this right now but my issue is that I am having to do math everytime and my updates are confusing because its not tracking how many hour they used THAT time its giving a cumulative total of how many they’ve used for the whole year. See below:
using employee “nderson” as example.
Say he used 24 hours of PTO last week, I go in and I add 24 (new PTO used) +13 (current hours used) and enter in the total = 37hrs into the hours used column.
A formula calculates hours left by subtracting that Hours Used number from the PTO for the year number. Yes, this is accurately tracking it but it’s not easily understandable about how many he actually used PER TIME. This is what the update/ email sent to the employee looks like
I want it to say 24 hours used on July 20th
37 hours used for the year
That way I can track how many hours were used per specific paycheck.
Sorry this was kind of confusing but I am hoping someone can help me!!