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

Question

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?

JammerS · Answer

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.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded