I am trying to track weekly inventory item usage so that I can deduct it from the master inventory amounts. This is the only part of my inventory system that I have not been able to automate via formulas. As an inventory item is used, a checkbox is checked and totaled. At the end of each week I manually deduct those totals from the master inventory amounts and then clear the Inventory Checklist to be used the next week.
I would like to be able to keep the "Total Week" amount so that I can use it in a formula to reduce the inventory automatically. Unfortunately I haven't figured out a way to do that because once I clear the checkmarks, the total returns to 0.
As a bonus, it would be great to have the checkboxes cleared automatically each week.
Thanks for your help in advance
