Searching multiple sheets

Mikie Doyle

Is there a way to search multiple sheets  when using a filter? Frequently we have multiple properties in the same subdivision and we are looking for a specific lot/block. The filters on our sheets work great we just have to do it multiple times to search all sheets. Just looking for a time saver. Thanks for the help!

Chris Winfield

The best way I can think of for this is to use a report - here you can specify whether to search everything, or restrict to a workspace for instance. 

Mikie Doyle

Thanks Chris. I had thought about that but I hadn't figured out exactly how to make that work.

J. Craig Williams

Mikie,

 

Did you figure this out?

 

I keep a "DEV" Report handy and use it as a search tool - change the criteria to what I'm looking for and run.

 

Craig

 

nicole.alejandro52046

This is helpful. 

We are trying to create a company-wide skills matrix.  Sounds like we can create multiple sheets (1 for each product line) in a single workspace and build a report to search for certain skills across multiple sheets. Please let me know if you have any pointers or recommendations.  Thanks!