Hi community,

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.

Example:

1. I add a new order manually to the spreadsheet “Orders”
2. The according number in the spreadsheet “Inventory” for the product goes from 5 to 4

Any tips how to achieve this workflow?

Thanks, 

Chris