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

Jeremy Myers
Jeremy Myers ✭✭✭✭✭
edited 12/09/19 in Archived 2015 Posts

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.






  • JohnHinkle
    JohnHinkle ✭✭✭✭✭✭

    Good ideas! I have a suggestion for you... have you used the reporting feature? Reports can pull rows from a single sheet or multiple sheets based on criteria you specify (think: filters). You can build a report that pulls in all the rows from your sheet you want to see (all rows except what you want to filter out) then you can sort the report however you want (without needing to remove any filters). Check it out: http://help.smartsheet.com/customer/en/portal/articles/522214-creating-reports

  • Jeremy Myers
    Jeremy Myers ✭✭✭✭✭



    Thanks for the reporting ideas to pull in rows based on filter or conditions.  I am on the <Basic> level account plan and would have to upgrade to <Advanced> to get reports.  Yell

  • paulo_neves
    edited 11/23/16

    I Have the same Issue..

    I work with a workgroup in a spreadsheet with our jobs and dates of delivery. We use it with dates and aplying filters, like ( finished - not show, Cancelled - not show, etc...) But while using those filters we can't sort the lines...

    We need to show the lines by date.

    Is there any other way?



    We use a report but just as a "mirror," published on some Smart TVS at several places in our office.



  • Jeremy Myers
    Jeremy Myers ✭✭✭✭✭

    Any sorting must be done prior to filtering.  There is no macro recroding capability, yet.

This discussion has been closed.