I have a pretty cool app for our sales rep firm, that has multiple sheets (using Google sheets) including inventory, pricelists backorder lists distributor invetory, etc…
How do I create a global search across ALL the sheets that would have SKU or common name and return all the results on 1 page?
Is there a way to link the sheets so they all get searched?
Currently still using the older APPS version, and have not transitioned to My Projects
Your only option is to have a detail style screen. On that screen add an inline list for each table you want to search. In the settings for each inline list, enable search. The search bar will display at the top of the screen and will search through each inline list where you have enabled searching.