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.
New Filtering and Filter sets
I appreciate the new Filtering functionality to make and share filter sets with users, great idea.
I have a refinement to suggest.
Can I ask to have a filter condition included to equate the value to a maximum or minimum value of the field?
is same as Maximum
is same as Minimum
This way when a maximum or minimum Value, or Date is common across multiple lines, they can be selelcted in a std filter.
E.G. in a project has several tasks are to be completed on the same day, using 'is same as minimum' would enable me to create a shareable filter to display all tasks equal to the minimum, thus those to complete first...
E.G. in a meeting record sheet with actions all marked as created in the last meeting. a filter set could be created with the meeting date " is same as maximum' to get all the actions from last meeting. Add to this a filter, a filter for <100% complete and its an outstanding actions list.
Also Applying this filter in the diplayed sequence (I hope this is what it does), would enable the flexibility of determining the minimum / maximum value to use.
E.G. Filter 1 <100% Complete Removes all the completed tasks with earlier than today dates.
Filter 2 Due Date 'is same as Minimum' give all the next taks to be completed or focused upon.
Setting these as filter sets, they could be repeatedly used .
A suggestion I can see being used......Add your like if this could help you.