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.
Filtering defeats sort function. Moving row to another sheet drops attachment link and forrmulas
1. I use filtering to hide rows with status <complete>, however when the filter is set, the sorting function is defeated. To resort, I remove the filter, sort and then reapply the filter. This is awkward and wastes a lot of keystrokes if done 20x per day.
Another bright idea was to archive the rows to another sheet titled <completed tasks>, but the system drops the document links and formulas - so that is a no-go.
2. How about a routine that will quickly cancel the existing filter by double clicking on an <x> next to the funel icon, then a dropdown box somewhere that you can invoke with a keystroke and shows a time sorted list of recent filters applied, you pick one on the list and the filter is instantly reapplied.