we are trying to build a really simple inventory management system within a Google Sheet.
Whenever a new row in another spreadsheet (“Orders”) is created, the number in a cell of another spreadsheet (“Inventory”) needs to decrease by 1.
- I add a new order manually to the spreadsheet “Orders”
- The according number in the spreadsheet “Inventory” for the product goes from 5 to 4
Any tips how to achieve this workflow?