So let’s say I’m counting inventory in a Google Spreadsheet and every time someone sends a payment I want the stock number to be reduced by 1.
I currently use Zapier’s ‘Update Spreadsheet Row’ action, but the problem is that I can only replace the content of a cell, but I can’t just reduce the value by the amount of 1.
So let’s say the value of that cell is 100 and I want to deduct 1 every time an action is triggered. How do I do that?
Best answer by SamBView original