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:
