Any suggestions on the following without using Dynamic View:
Hi @Gladys Liley
The way I would do this is to Publish a Sheet and embed it in the Dashboard with the Web Content Widget. Then I would have a number of pre-set Filters on this sheet that users could choose from as their sort of "search" bar.
If you only want to show certain columns from your sheet, you could set this up as a second, helper sheet with cross-sheet formulas or cell links gathering the data (so as not to share the other data/columns).
Would this work for you?
I like this suggestion :) I will try it and share results.