Sorting Rows

Hi, I am working on something that requires to sort the Smartsheet based on a column.
The type of column is 'TEXT_NUMBER'.
1/0/12
1/0/1
1/0/14
1/0/3
1/0/11
After sorting the smartsheet with the above column the result is this
1/0/1
1/0/11
1/0/12
1/0/14
1/0/3
I am using python sdk in my project, but it doesn't sort all the rows, the rows are sorted in some chunks.
Like some of the rows are sorted together and some are not.
Has anyone faced similar issue?
If yes, how was it resolved?
Best Answer
-
Hi @dark_knight ,
Smartsheet is treating your numbers as text when it sorts. You'll find several work around posted in the Community. If you can, the easiest solution is to use leading 0s to make your numbers the same length/format so they sort correctly as text:
01/00/11
01/00/12
01/00/14
01/00/03
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @dark_knight ,
Smartsheet is treating your numbers as text when it sorts. You'll find several work around posted in the Community. If you can, the easiest solution is to use leading 0s to make your numbers the same length/format so they sort correctly as text:
01/00/11
01/00/12
01/00/14
01/00/03
Help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Thanks @Mark Cronk
As per the requirements I can't make my data in that format.
But thanks, now I got it that the issue was because it is taking it as a text.
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