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 )
THX
Krafty
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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