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:
+6
Hi
It looks like the ISBLANK function would only return a true or false value. It wouldn’t allow you to output a “0” value if it’s blank. To output a “0” you’d need to use an IF formula. For example:
That said, it looks like you’ve got a field selected that contains line items so that formula won’t work. But perhaps you could try using a Formatter (Text > Spreadsheet-style formula) action.
More about this here:
Hopefully, this helps! 😊
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
