Sorting Rows

dark_knight

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?

Find more posts tagged with

Sheets

API and Developers

IT & Operations

Accepted answers

Mark Cronk

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

All comments

Mark Cronk

Hi @dark_knight ,

01/00/11

01/00/12

01/00/14

01/00/03

Help?

Mark

dark_knight

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 to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.