LinkedIn
Twitter
In my Google Sheets app, I have a stock inventory and inventory log. My issue is that I want the item quantity to auto-update whenever I perform a transaction (such as cutting, changing location, or scrapping). So far, both cutting and changing location work, except for scrapping.
Whenever I select "scrap" on the app, the Google Sheet updates with another row for the scrapped item. However, when I dispose of the scrap, the original item quantity still remains unchanged. Only the quantity of the item moved to scrap is changed to zero. I would appreciate any suggestions on how to fix this. Thank you.
