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

[Boskak Bruce]

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

 

[ArshilAhmad]

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]

That's unfortunate. Thanks for replying.