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 ✭✭✭✭✭✭

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 ✭✭✭✭✭✭

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 ✭✭✭✭✭✭

01/28/22

Happy to help. 👍️

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

Categories

Trending in Smartsheet Basics

Where are the AI (formula generation) icons now? 2025
Before, I was used to seeing the AI icon listed on the right side menu, at the bottom. where is the AI formula generator icon now in 2025?
Disable Comments for a single Sheet?
Is it possible to disable the use of comments on a single sheet? Or is there a way to get an alert to someone, perhaps sheet owner/admins or a special group when there is a comment added?
search function not bringing user to the row of the "found" item.
Hello, Some of our users are noticing search issues today with wildcard searches in grid view. The search function searches properly however is not bringing user to the row when clicking the found item. In some cases clicking the up or down arrow on the keyboard will refresh it, for others it's no where near the item in…

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