Best answer

How to use spreadsheet-style formula on columns that are sometimes empty

  • 13 January 2021
  • 2 replies
  • 368 views

Userlevel 1

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?

 

icon

Best answer by Larry Talley 13 January 2021, 01:30

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 1

Ok, my bad. I figured out that I must enclose things in quotes, even references to Google sheet columns.

I get no errors with the new code:

IF(ISBLANK(" 1. Actual_Arrival_Date: No data"), " 1. Calculated_ETA: 2021-01-15 7:12:34"," 1. Actual_Arrival_Date: No data")

The entire zap isn’t quite working yet but I am now moving past this problem.

Userlevel 7
Badge +12

Thanks for lettings us know that you found the answer to this one,  @Larry Talley 🙂