Question

Decrease Google Sheet Cell by 1

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:

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?

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.

Userlevel 7

+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

+10

Hi @snowwhite

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

Sign up