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
-
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.
-
Danielle,
Unfortunately its not a drop down but a Text/Number column.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives