I am attempting to use the spreadsheet-style formula below with some content from a Google sheet:
IF(ISTEXT({{109858925__COL$K}}), {{109858925__COL$K}},{{109858925__COL$S}})
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 Talley
View original