i am not able to sort in smartsheet reports when Multiple source file(sheet) is selected?
I am trying to sort based on the YTD summary, which is a numerical value, but Smartsheet won't allow me to sort it, it sorts automatically based on the alphabetical order which is available on primary column. Anyone faced this issue or have any solution for this?
Best Answer
-
Hi @Ramakrishnan S,
You can sort the rows with multiple underlying sheets.
I suspect you're trying to sort the Groups based off your screenshot. That you cannot do.
All the best,
-Ray
Answers
-
Hi @Ramakrishnan S,
You can sort the rows with multiple underlying sheets.
I suspect you're trying to sort the Groups based off your screenshot. That you cannot do.
All the best,
-Ray -
@Ray Lindstrom Thank you for your comment, Yes i was trying to sort the groups. This is unfortunate that we cannot group based on it. i need it for my report.
-
No problem, happy to help! What you're trying to accomplish would make for a great Product Idea submission (if one isn't already submitted that you could upvote).
Let me know if you end up submitting or finding one, and I'd be happy to upvote it.
If you don't mind, please mark my first response as being the answer. This helps other users find answers.
Thanks and all the best,
-Ray
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!