Empty quantity field in Xero won't return a value in Google Sheets using IF(ISBLANK)

  • 4 October 2023
  • 1 reply

Userlevel 1

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:


1 reply

Userlevel 7
Badge +6

Hi @Haydn,

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:

(view larger)

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! 😊