Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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!
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.
Thanks Chris. I had thought about that but I hadn't figured out exactly how to make that work.
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
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!