Forum Discussion
Need help finishing this inventory file
Hi- I've been working on creating an inventory log for my work. I manage a lot of spare keys, and they only get used if I have to replace broken keys on active sets, so I needed not only a physic...
I think you want the INVENTORY to be =SUMIFS( ActivityLog[In/Out], ActivityLog[Key], [ID #])
BTW i recommend formatting both sheets as TABLES and name the Activity Log something like ActivityLog (as I used in the example above) and the Inventory Log as Inventory
To make the Inventory log correct you may need to insert a set of initial values like:
Key1 ... +12
so that starting today it shows 12 of those keys in inventory
then Joe adds to the log and say Key1 ... -1 and the inventory goes to 11
That all said, know that the Inventory column on the ActivityLog will show the PRESENT inventory and not the inventory back when that log entry was added.
BTW i recommend formatting both sheets as TABLES and name the Activity Log something like ActivityLog (as I used in the example above) and the Inventory Log as Inventory
To make the Inventory log correct you may need to insert a set of initial values like:
Key1 ... +12
so that starting today it shows 12 of those keys in inventory
then Joe adds to the log and say Key1 ... -1 and the inventory goes to 11
That all said, know that the Inventory column on the ActivityLog will show the PRESENT inventory and not the inventory back when that log entry was added.