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.
Reports sort dropdown columns differently than a regular sheet
Comments
-
Hi Tom - As you have seen, sorting Dropdown lists is different in sheets and reports. In your sheet they are sorted based on the order of your predetermined dropdown values (what you see under Column Properties). While in a report, the Dropdown list is sorted alphabetically. There isn't a way at this time to sort your report based on your predetermined dropdown values.
-
Tom,
Add a Hidden column in the Sheet that contains an IF Function to look at the Value in the relevent cell and return either A,B,C or 1,2.3 i.e A or 1 = High, B or 2 = Medium and C or 3 = Low. Add this column to the Report and sort by it.
-
Guys, I am frustrated by the same issue. Weird you cannot implement the same logic.
Any ETA to resolve this?
-
Ilan - there are not any plans to change the functionality to sort a report based on the order of the dropdown list predetermined values (vs alphabetically) but I will add your vote for this enhancement request!
-
Thank you Travis. In the meantime I changed all my sheets to a 1,2,3 priority config. in order to workaround this limitation.
Not great as UX to do so, but I'm over it.
-
Travis, I would like to add one more customer vote to make sorting on reports as robust as it is on sheets. I understand the work-around, but it should not be necessary.
Love Smartsheet - please fix this anoying little disfunction. Thanks!
-
I agree. Just found this out and have to add the number value workaround to several sheets aggregated in a report.
-
Hi,
I'm having problems sorting my report alphabetically.It was working fine before but now i cant sort by the names of the assigned to alphabetically and i'm hoping someone can help me with this.
I've tried creating a new report and i'm getting the same result.
Thank you!
-
Add my vote as well. This would be super helpful to have feature parity in Reports.
-
Hi everyone,
Please submit an Enhancement Request when you have a moment to have your vote added
A New Way to Submit Your Feature Requests
To make your Enhancement / Feature Request count, send in the form above because there isn’t a guarantee, it will be registered otherwise.
Original Post: https://community.smartsheet.com/announcement/new-way-submit-your-feature-requestsHope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives