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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives