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

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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. 👍️

Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
Is there a way to merge user groups?
Two teams at my company have recently merged into one, and I was wondering if there's an easy way to merge their Smartsheet user groups into one group. I don't see a "merge" option available in the Group Management portal.
Attendance reports
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition? Please…

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