Sorting in a report
![Melitta](https://us.v-cdn.net/6031209/uploads/userpics/O5EZE8SL5PVX/nFGMNU1W01BER.png)
I am filtering information on a report by Start Date in between Jan 1 and Dec 31 of 2022, start date is in the future, and in the next 120 days. Grouping it by month (January - December). This is populated by a helper column formula that takes the month from the start date and converts to the month.
I am grouping the report by month and sorted.
However, it shows March followed by January and then February.
Why? clearly it's not alphabetical. How do I get it to sort January, February, March....?
Any thoughts?
This form is not allowing me to upload a screen shot.
Best Answers
-
That is because the Month column is housing text values. It is sorting based on the text string, so technically "F" comes before "J" comes before "M", so on and so forth.
You will need to change your months so that they have "numbers" placed before the text.
"01 January""
"02 February"
"03 March"
etc....
-
Hi @Melitta
I hope you're well and safe!
You'd need to add a so-called helper column that would show the month or modify the current one with something like 01-January, 02-February, etc.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
You can update un screenshot in comments it this
or copy pasting
-
@Christian G. , The Attach or picture links/icons aren't working for me but your suggestion of copy/paste did. So, thank you very much.
-
Hi @Melitta
I hope you're well and safe!
Can you share a screenshot of the report settings (Conditions, Group and Sort)?
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Can you put a screenshot of the repport filter, Group and the formula for the "month" column in the sheet?
-
Here is a screen shot of the filters:
as well as the group:
Yet as you can see, it has March, January, February.
If I switch Group by to Sort Ascending, it then displays as February, January, March.
Any ideas of how I can get it to group under Month, and have it sorted from January - December?
-
It looks like you don't have any sorting applied at all.
-
-
That is because the Month column is housing text values. It is sorting based on the text string, so technically "F" comes before "J" comes before "M", so on and so forth.
You will need to change your months so that they have "numbers" placed before the text.
"01 January""
"02 February"
"03 March"
etc....
-
Hi @Melitta
I hope you're well and safe!
You'd need to add a so-called helper column that would show the month or modify the current one with something like 01-January, 02-February, etc.
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives