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

"Record a Date" Automation to a Cell in a Hidden Column
I have lots of sheets for a reviewing process - each item to review has a new sheet from a template. Each sheet has about 30 rows and a summary sheet. I have an automation that does the following: When "status" cell changes, request an approval. (This is calculated in a summary sheet and written to a cell.) Approval comes…
How to share WorkApps with view only colleagues on an enterprise plan?
Hello! We have an enterprise plan for our company and with 2 licenses on it. I have created a workapp to share some sheets and share a dashboard in one place. Yet I am not sure why I got this message from them when they tried to access it. Could you please help as from my understanding this should be free on the plan we…
Would it be possible to copy rows to another sheet on a specific day of the week
If I was to use an =today() in a column to grab the current date and then a condition using the IF(WEEKDAY(Date@Row) = 1, and make an automation for say, every Monday (1), could I copy a row (or rows) to another sheet when that day condition gets triggered? I will try this as I think it should work…..but I am fairly new so…

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