Help with sorting numbers and letters that are combined in one cell?

I would like to sort by a column that has both numbers and letters in a cell. Such as 1, 1a, 1b, 1c. Right now if I sort it by it by the ascending option, it's able to do 1a, 1b, and 1c correctly, however it separates it from the numbers that don't have any letters. For example:
This is what it does:
1
2
3
1a
1b
2a
2c
3b
3c
This is what I want:
1
1a
1b
2
2a
2c
3
3b
3c
Any help or suggestions? I can't figure this out. I wish there was a custom sort option like in Excel. Thanks!
Answers
-
@lexir223 Honestly I do not think there is any way to get it to sort the way you are wanting it to. Sorry to be the bearer of bad news. Maybe someone else can provide you with a workaround but I have not seen this problem solved yet.
Melissa Boehl
Smartsheet Architect | TurningPoint Energy
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives