Create a Filter by Keyword for most frequently used criteria

Nikita Che · 11/05/24

Dear Community, Filters in Smartsheet are great, but I am looking for a solution to create a filter by keyword, where a user could paste the most frequently used value (i.e order number) in just one click. Think of MS Planner filter or a solution in the old Access. Please point me in the right direction.

ChristianFinke · 11/05/24

Hi @Nikita Che

While Smartsheet doesn’t have a single-click keyword filter like MS Planner, you can create a workaround. Set up a Sheet Summary field or cell where users can enter a keyword (like an order number), then create a Filter that references this cell to update results. Alternatively, use Reports for a dynamic search across multiple sheets.

Hope this helps! Let me know if you'd like to discuss further.

Create a Filter by Keyword for most frequently used criteria

Answers

Categories