Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition.
Because we share our SmartSheets with multiple teams, I would like the ability to add an "or" condition for two rows. If a row is completed we add a finish date and the filter hides the row. I would like to add a condition to continue displaying the rows for 3 days after the Finish column has been populated with a date. This will give other users an opportunity to view the row for a few days until it is hidden.
Here's a screenshot showing the desired functionality.
Enhancement Description: Ability to add an "Or" condition between the two rows below.
Comments
-
I would use such a feature, but have difficulty so late at night of seeing the implementation that would fit into the current GUI design.
Luckily, not my job.
Craig
-
Hi
I would certainly use this if available. Other apps I use offer a choice of and / or in selection filters and it would enhance SmartSheet.
Chris
-
Hi All—
I've got your votes down for an OR operator in sheet filters on our enhancement request list for further consideration.
As a potential workaround in these situations, you might see if you can create a report that pulls in the rows you need: https://help.smartsheet.com/articles/522214-creating-reports
-
e.g. like this fake screenshot
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives