Search/Filter

BCOPEY

Hello I am new to this and am on my trial and am wanting to use this to build a search/filter for lots of different office furniture categories and then specific options within each category at lots of diff price

points.  I'm having a hard time figuring out how to create something similar to this.  Does anyone know if there are any training videos that could just help me get started figuring out how to do this?

thank you in advance!! - Brad Copelin  

Andrée Starå

Hi Brad,

My recommendation without knowing more about your specific use case.

Different sheets for the types of furniture and then a report to collect everything in an overview.

I just recently worked with an interior decorator with a similar scenario.

I hope this helps you!

Best,

Andrée

Pam Alakai

Hello, 

I would recommend using hierarchies to create furniture categories within your sheet and subcategories (options) within those categories. Learn how to create hierarchies here: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows 

Once you have created the sheet, you can use filters to only show specific data from your sheet: https://help.smartsheet.com/articles/504659-using-filters-to-show-or-hide-sheet-data

You can also use reports to pull a specific category or data from your sheets: https://help.smartsheet.com/articles/522214-creating-reports

Kind Regards, 

Pam 

Technical Support Specialist