I’m creating Multiple Spreadsheet rows in Google Sheets from a Xero invoice.
If the quantity is left blank, I’m trying to return a ‘0’ in the Google Sheet, but can’t seem to make it work.
(an empty cell in Google Sheets won’t let me fill an order in Track-Pod, the zap stops at this point if I don’t have a value in the cell).
I’m using the following formula:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/9283c3ea-49f7-46d6-b387-510c98ee56d2.png)