Report Sort Order Seems Broken
![Umesh Shah](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have a list of products by t-shirt size, (S,M,L), i wanted the specific line items to be grouped and sorted by t-shirt size, but it only sorts them as L,M,S in alpha order.
So i created a helper column called sort order which assigns 1=S, 2=M and 3=L.
When i sort the report by sort order it works, but as soon as i group it by t-shirt size the sort order goes back to alpha by t-shirt size eventhough i specifically have the sort to be by the column "sort order"
Why is this happening? Is this a bug?
Answers
-
The grouping will always override sorting, but you can adjust the sort order of the grouping when creating the grouping.
-
how do i adjust the sort order of the grouping? it always groups alphabetically, i don't want that.
-
In the case of S, M, L being sorted as L, M, S instead would be changing the sort order from ascending to descending when grouping.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives