I am attempting to use the spreadsheet-style formula below with some content from a Google sheet:
but I get error “The numbers could not be sent to Formatter by Zapier.” and I am presuming that the error is because ISTEXT doesn’t evaluate correctly on a null value? I have tried “ISBLANK” with identical results.
Does anyone know the best way to implement “if this is not null/blank/empty use this, otherwise use that” in a Zap action triggered by a Google sheet new row or updated row?
Best answer by Larry TalleyView original