Wrong Sorting

I have an issue where I've created a report to pull information from multiple sheets and want to do two "groupings", one by "type" which is 3 Month, 6 Month, or 12 Month and then by "owner". Sorting by owner is no issue. When I group by type I want it to be in numerical order but whatever I do, it doesn't sort properly.

If I sort ascending then it sorts 12 Month, 3 Month and then 6 Month. If I sort descending then it sorts 6 Month, 3 Month and then 12 Month.

How do I get it to sort so it shows up 3 Month, 6 Month and then 12 Month?

Find more posts tagged with

Accepted answers

Mike TV

@Jodi C

Try sorting them Descending and add a period to the front of the 3 Month name. See if the period makes the 3 month appear first. If not a period, try another innocent character that doesn't make it look too bad.

I know why it's doing that. Its because SmartSheet is only looking at the first letter (or number in this case) and sorting it by that instead of realizing it's a number and seeing if another digit is following it. This is a situation of DumbSheets that needs an Enhancement Request to make it act properly.

Andrée Starå

Hi @Jodi C

I hope you're well and safe!

To add to Mike's excellent advice/answer.

Another option would be to structure it like 01, 02, 03...

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

All comments

Mike TV

@Jodi C

Hi Jodi. Are you able to show a screenshot of this happening and how you've got it set up without revealing sensitive info on the sheet?

Jodi C

Sort Ascending.png

Sort Descending.png

@Mike TV Attached are two photos that show the grouping both ascending and descending.

Mike TV

@Jodi C

Jodi C

Thanks @Mike TV!

Looks like adding a period to the front of the 3 & 6 makes it work.

New Sort.png

Andrée Starå

Hi @Jodi C

I hope you're well and safe!

To add to Mike's excellent advice/answer.

Another option would be to structure it like 01, 02, 03...

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.