Sorting
Hi @Mark Cronk ! Question for you, how would I sort the data shown below? i.e. so that the "Approved" are all together, and so on
Best Answers
-
Hi @Erick Gutierrez,
Are you trying to sort information in a sheet? If so, the steps are pretty easy.
1) Right click on the column you are trying to sort.
2) In the pop up menu select Sort Rows.
3) You should see the column name in the Sort Item By field and Sort Ascending should be defaulted to automatically.
4) Click Ok.
All the best,
Sandra
-
Hi @Erick Gutierrez,
You can sort in descending order Z-A using the same steps above. I have attached the link for information on sorting in Smartsheet. It goes into detail as to how information is sorted.
Hope that helps.
Sandra
Answers
-
Hi @Erick Gutierrez,
Are you trying to sort information in a sheet? If so, the steps are pretty easy.
1) Right click on the column you are trying to sort.
2) In the pop up menu select Sort Rows.
3) You should see the column name in the Sort Item By field and Sort Ascending should be defaulted to automatically.
4) Click Ok.
All the best,
Sandra
-
Thank you that worked, is there a way to sort by a different order other than A-Z?
-
Hi @Erick Gutierrez,
You can sort in descending order Z-A using the same steps above. I have attached the link for information on sorting in Smartsheet. It goes into detail as to how information is sorted.
Hope that helps.
Sandra
-
Thank you! @Sandra Guzman
-
Do be aware that sorting is undoable on a sheet. An alternative method is creating a report including all the columns you want and then sorting the report itself. It will not mess with your original data and give you a sorted view of the data.
-
Thanks for the assist @Sandra Guzman and @Mike Wilday !
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
To add to the previous excellent advice/answers.
I'd recommend adding an auto-numbering column, and then (depending on your process) you can always get back to the default sorting.
Would that work/help?
I hope that helps!
Be safe and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
-
@Andrée Starå Nice value add. And would help undo the process too.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 405 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives