Question

Decrease Google Sheet Cell by 1

  • 24 August 2020
  • 2 replies
  • 46 views

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.

 

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


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.

COUNTA: https://support.google.com/docs/answer/3093991?hl=en

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?