Sorting more than 9 sheets within a report

Hi,
I have created a report which contains 25 sheets and data contained within each. To keep the view simple I am grouping by sheet name so each "chunk" of data relates to a single sheet.
What I would like to do next is sort the report using the sheet names. I have tried multiple ways of doing this but cant get what I want.
I have tried re-naming each sheet with an incremental number to start with. This works nicely for the first 9 sheets, but when we run into double digits smartsheet is putting all the '1's' together eg 1, 11, 12 instead of 1, 2, 3
I have tried this also with letters but smartsheet doesn't seem to recognize the single letters at the beginning of the sheet name.
Would anyone have a solution I can use in order to sort sheet order in a report where there is more than 9 sheets?
Thanks,
Answers
-
Hi @AlishaO
I hope you're well and safe!
Try something like this.
01, 02, 03, and so on, and it should work.
Did 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.
-
Hi,
No sorry this isn't working. for some reason some of the numbers do not show even after i save and refresh.
Is it because I am grouping by the sheet name also?
-
Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
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.
-
Hi, See attached screenshots.
- The way i have named the projects
- the way they are showing in my report
- the way i have grouped
for some reason, no matter how many times i refresh, the report is not picking up the numbers i have used in the sheet name.
-
There is sometimes a delay (I have seen a day or more on rare occasion) in the sheet name being updated on the back end.
Try logging out, clearing cookies and cache, then logging back in again to see if that helps push through the sheet name updates.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives