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
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 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