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.

Sort Sheet Excluding Top Rows

Options
Stacy Eley
edited 12/09/19 in Archived 2016 Posts

I have a sheet and need to be able to sort the sheet except for the top few rows as they are linked to reports / sights.  How can I do this?

Comments

  • Stacy Eley
    Options

    I should clarify that I would like to do it by clicking the header and sorting, not selecting all the rows I want sorted and sorting.

  • John Sauber
    John Sauber ✭✭✭✭✭✭
    Options

    A workaround could be to have a checkbox column called something like "Top Rows" and sort on that first (decending), then sort with your other rules. Of course, you only get 3 levels of sorting, so this burns one of those.

This discussion has been closed.