How to Search for data in ALL sheets in a Google Spreadsheet.

Status: Open · Asked by Boskak Bruce on Jul 25, 2023 · 0 views

Boskak Bruce — Question · Jul 25, 2023

Hi guys,

I've got 10 sheets (tabs) in my Google Sheet. The data I'm looking for could be in a cell in any of those sheets. How do I search all of them. I can only see options for searching one specific sheet for data.

Thanks so much,

Bruce

Arshil Ahmad — Reply · Jul 25, 2023

Hi @Boskak Bruce,

In Google Sheets: Lookup Spreadsheet Rows action event can only search for data within a specified sheet. For your use case, you will have to add 10 steps to your workflow, each for a different sheet.

Boskak Bruce — Reply · Jul 25, 2023

That's unfortunate. Thanks for replying.

Back to all forum threads · Log in to reply