Sorting Rows

edited 12/23/20 in API & Developers
12/23/20 Edited 12/23/20
Accepted

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

  • Mark CronkMark Cronk ✭✭✭✭✭
    edited 12/23/20 Accepted 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

  • Mark CronkMark Cronk ✭✭✭✭✭
    edited 12/23/20 Accepted 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.

  • 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.

Sign In or Register to comment.