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.

Question

How do I find all rows with any data in a specific column using Zapier?

  • August 15, 2024
  • 2 replies
  • 284 views
F

I have a google sheets spreadsheet with rows of data about various projects. When a user has a run date for their project they mark it in a specific column. The info in the run date column is not in any specific format. It could be a date or just the name of a month or even just something like “soon.”

 

I need to be able to find all the rows in this sheet that have ANY kind of data in the run date column. The catch is I cannot add more columns to the sheet. 

 

Is there a way to just look for ANY value and return all those rows?

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

JammerS
Forum|alt.badge.img+6
  • JammerSZapier Staff
  • Zapier Staff
  • August 16, 2024

Hi @Fred H,

 

Welcome to the community. Try this in your Zap. In Google Sheets (or your spreadsheet service), choose "Search Rows."  select the spreadsheet and worksheet, and in the "Search Column" field, enter the column name you want to search. Use a wildcard character (*) to find any data in the "search Value" field. After testing your Zap, please turn it on. Now, Zapier will search for rows with any data in the specified column whenever the trigger event occurs.

zaki_readylogic
Forum|alt.badge.img+1

The issue you are dealing with can be handled within Sheets by utilizing a filter for empty cells in that specific column. I don't comprehend why you need to integrate it with zapier.com.

Zaki Imtiaz
Terms & ConditionsAccessibility statement