Is there a way to create a search box?

We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?

Find more posts tagged with

Forms

Sales

Templates

Sheets

API and Developers

Healthcare

Formulas

Services

Integrations

Marketing

Support

IT & Operations

Product Development

Conditional Formatting

Project Management

Cell linking

Comments

Andrée Starå

Hi Jess,

If you publish the sheet so they could use the search function.

Another way could be to use filters maybe.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Jess Merritt

Andrée,

That is what we would like to avoid because it tens to confuse our customers. We are hoping to keep it simple so all they see is a search box and short description.

Thanks,

Jess

Andrée Starå

Happy to help!

How many records is the database?

Best,

Andrée

Jess Merritt

1037 rows.

Andrée Starå

I might have a way.

How many different objects do they need to search for?

Jess Merritt

Roughly 4148. However, hat number is a little high because each row in theory should have four searchable fields, but some have only two or three.

Jess Merritt

Basically we have a spreadsheet with about 1,000 items. Each item has four different codes. We want for the public to be able to search for the items by any of these numbers or by the item name. I was hoping that a template or dashboard could be made that provides the end user with a search box and then returns any matches based on the Smartsheet in the background that is linked to the public facing sheet. Is this possible?

Andrée Starå

Can you share the sheet, screenshot or some example data so I can get a better understanding of the structure?

You can share the sheet with me at andree@getdone.se

Best,

Have a fantastic weekend!

Andrée

veevee

Hello,

were you able to find a solution for this? I have the need to do something similar.

Andrée Starå

Hi,

How would you like to use it? Can you describe your process?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Reni Viessmann

https://community.smartsheet.com/discussion/comment/116491#Comment_116491

Hi Andree

I am struggling with the same issue. I want to provide a search function for public viewers. Unfortunately it doesn't work to use STRG + F on a published sheet with read only permission. Furthermore, shared filters cannot be edited on published sheets. I can't find any way to provide a search function either on my dashbord nor in my master grid for the public viewers. I would really appreciate your hints. Thanx Reni

Jacob A

Was there any resolution to this question?

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…