Sorting Rows

dark_knight
edited 12/23/20 in API & Developers

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