Issue sorting rows

Looking to understand what could be causing an issue with my row sorting. It seems to have sorted the 1st half of rows and then starts a-z sorting again later on in the sheet. Is this because someone else is using a shared filter? And if so, how do I get round this?

Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    Hi, Angela. What type of column is the column you're using to sort? If the column is a Dropdown List column, Smartsheet will first sort (A-Z) the column values that are listed in the dropdown menu options. If there are values that are not in the dropdown options, those are then sent to the bottom of your list and sorted A-Z.

    My best guess is this is what's happened to you. The quickest fix (if it works for your data structure) is to add the values at the bottom of the list to your dropdown options, then re-sort your list.

  • Angela Logie
    Angela Logie ✭✭✭✭✭

    Danielle,


    Unfortunately its not a drop down but a Text/Number column.