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.
