Enhancement Request: Filters to include and / or functionality

jcamer25

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. 

J. Craig Williams

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

cjab

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

Shaine Greenwood

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

Joachim Mund

e.g. like this fake screenshot