Sorting Rows in Reports

Hi, anyone know of a simple way to sort rows in a report?

I've got the Smartsheet 1,10,11,……,2,3,4 etc issue going on. I assumed if I sorted the Sheet correctly, then the Report would follow the rules of the sheet, to be able to present in a logical manner in a Dashboard.

Here are screen grabs of the Sheet and the Report

It just looks like I've lost the plot.

Cheers

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

You'll need to add leading zeros so that all numbers are the same number of digits.

PM_Reeves

Cheers @Paul Newcome,

Never thought of that as the original data comes form an auto-number column.

Have a great day

Paul Newcome

Happy to help. 👍️

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.