can i create an easy user interface for searching a spreadsheet
We have a hidden sheet we don't want people to see and have a dashboard with links to forms, reports and calendars, but now have enough lines we need to build out a search function. Each line is a test request meant to keep for years. How could we create a search function to look at a report or the sheet to narrow down their info based off of a value from a couple of the columns? This might look like, machine #, date range, key words, requestor....
First post -sorry if I missed the answer in a previous one (I did search )