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
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
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
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
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
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Change default SS email address when automation sends information to Track-it!
We are using Track-it! for all helpdesk requests. When a remote user wants to check on inventory, request samples, etc., they are sending an email to a specific email group. Sometimes all the information is provided and other times not. I created an intake form in SS with the fields needed for all requests, including the…
Two drop-down lists tied by logic with one another
Hello, I am a novice to SmartSheets. My first challenge is to create a form where when users select a department in one drop-down list, another drop-down list displays only those individuals belonging to department chosen in the first drop-down. So far I read articles talking about needing to set up an automation rule, but…
unable to hide columns
I am unable to hide columns - the option is grayed out or unavailable. Any advice? Thank you

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