Decrease Google Sheet Cell by 1

  • 24 August 2020
  • 2 replies

Userlevel 1

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.



  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?




This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +14

Probably easiest to use a GSheets formula.


May depend on how you have your GSheet inventory tab structured.

Otherwise, if you want to use Zapier, then do these actions


Action: GSheet - Lookup Row

Action: GSheet - Update Row

Userlevel 7
Badge +10

Hi @snowwhite 

Just checking in. Were you able to get this sorted?