Sorting Rows in Reports

PM_Reeves

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

Paul Newcome

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

01

02

03

04

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. 👍️