Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

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

  • January 13, 2021
  • 2 replies
  • 560 views
L

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

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.

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

L
  • Larry TalleyBeginner
  • Author
  • Beginner
  • 2 replies
  • Answer
  • January 13, 2021

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.

Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • January 13, 2021

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

Terms & ConditionsAccessibility statement