Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Can a filter be applied to an already filtered list?
We are looking into transitioning our MS Access Drawing Index into Smartsheet. We need it to have the same filtering and search capabilities if we are to move forward with this transition. In the attached example, I need to filter the sheet so that it displays all records that contain the word "creek" in "title1" OR "title2". I then need to filter that filtered list to only show records that are project "A" AND subproject "02". Is there a way to accomplish this in smartsheet?
Best Answer
-
You would need to insert a helper column with a formula that combines both titles into a single field. This column can be hidden after setting it up to keep from cluttering things but still accessible in the filter.
=[title1]@row + [title2]@row
Answers
-
Hi @tlechi
Yes, you can do that with filters on a sheet in Smartsheet. You can also do that with reports which are basically pre-set views (filters and specific columns) that you can embed in Dashboards with other KPIs. Or just use as stand alone reports that look almost exactly like the sheet. Anything you do in the reports, updates the sheet and vice-versa, all in real time with multiple reports.
I hope that helps.
-
Reports are not an option for our users in this instance. I only want to give access to the sheet and I am not seeing a way to apply two filters in a sheet. In my initial post I've applied a filter "creek" that returns rows where "creek" is in "title1" OR "title2". I now need to filter those results to only show rows that have [project] "A" AND [subproject] "02". Can you give me an example on how to do this?
-
You would need to insert a helper column with a formula that combines both titles into a single field. This column can be hidden after setting it up to keep from cluttering things but still accessible in the filter.
=[title1]@row + [title2]@row
-
Simple. Exactly what I was looking for. Thank you SS team.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day …
- It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…
- This discussion was created from comments split from: How to add logo in smartsheet Forms?.
