can i create an easy user interface for searching a spreadsheet

Mr.Kraft

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 )

THX

Krafty

Andrée Starå

Hi @Mr.Kraft

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mr.Kraft

This is a report of the "closed" test. we are creating about 50 a month so will soon have thousands. I want to be able to have a user find a test that was run 8 months ago based off of search criteria.

THX