Sorting ascending order (monthly)

SIS

SIS ✭✭

01/27/22 in Smartsheet Basics

Hi,

I'm having trouble organizing the column in ascending order. I'm trying to plot this into the dashboard and after Jan comes Oct as

sort ascending by monthly order.PNG

I'm trying to group them together. Before I tried not to put a number before the month that messed up the order more. Not sure how to fix it.

Any input will be appreciated.

Tags:

0 ·

Best Answer

Paul Newcome Community Champion

01/27/22 Answer ✓

You will need to use 2 digit numbers.

01
02
03
04
05
06
07
08
09
10
11
12

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
1 · Share on Facebook Share on Twitter

Answers

Paul Newcome Community Champion

01/27/22 Answer ✓

You will need to use 2 digit numbers.

01
02
03
04
05
06
07
08
09
10
11
12

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
1 · Share on Facebook Share on Twitter
SIS ✭✭

01/27/22

Paul worked like a charm! Thanks!

0 · Share on Facebook Share on Twitter
Paul Newcome Community Champion

01/28/22

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Column descriptions
Hello, Why i do not see Column Descriptions in the Report? thanks!
Why sheet viewed - No action taken - but in Activity Log list Formatting Applied, Why?
Hi this can be mis read as action taken. WHEN ONLY SHEET VIEWED. Unless embedded formatting is doing itself (wild guess). Need to understand where/why this line of log came from. Thanks, Jinwon
Non Licensed User - Editor Access - Update Columns
Hi - Has anyone experienced this? I have an unlicensed user shared to a sheet with a form with Editor access. I can see in Activity history she was able to change column properties for a column from Text to Date. Has anyone had this happen? I am wondering if she somehow edited the form?

Help shape the future of Smartsheet.
Share your ideas and feature requests.