随着行添加&细胞值变化,great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!
We love this idea! The ability to configure your sheet to automatically sort is part of our long-term roadmap. We'd like to learn more about your specific requirements; please add more information to this thread so we can understand how this feature will work the best for you.
This would be very helpful, especially when there are multi-row sorts to do when new data is entered. I'd love to see this as an automation similar to the Move/Copy Rows. Sort Rows based on a trigger.
This has clearly been submitted multiple times before over the past two+ years based on the community discussions, but here's what we need:
In grid view, set up a rule to autosort every time the sheet is loaded.
Use case:
My team needs to sort all of our projects into buckets that show all the projects for each business unit grouped together. I set up a hidden column called "Sort by BU" and created mock "header" rows in grid view since headers are also not supported in Smartsheet (another feature you need).
I unhid that column for this screenshot:
By labeling the "header" rows in the hidden column "A, B, C," etc., and sorting first by the BU column and then by the "Sort by BU" column, I am able to keep the "headers" at the top of each BU section.
In this screenshot, this is just a small mocked up sheet. We will have hundreds of projects in here and I really need them to sort properly every time without someone having to reapply the sort every time we open the sheet in case a new project has been added. There is a large risk that the sort will be applied incorrectly or forgotten otherwise.
We love this idea! The ability to configure your sheet to automatically sort is part of our long-term roadmap. We'd like to learn more about your specific requirements. If you'd be willing to chat, it would help us understand how this feature will work the best for you. Please schedule time athttps://bit.ly/3Jbcfos.
Related: we need to be able to save sorts. As a Smartsheet user since 2011 I recognized this need early on, and I’ve been asking for this for over ten years.
It would be helpful to be able to automatically sort rows within a column from highest to lowest - that way when we enter a new value, it will automatically sort within the columns after we refresh the page. As of now, whenever we enter a new value we have to remember to re-sort it every time.
Hello! I'm hoping one of the next big waves of feature updates could be improving the 'sort' and 'search' options.
It gets frustrating having to re-sort my rows constantly while my data gets manually or automatically changed frequently. There should be an option to 'lock' a sorting option so everything auto-sorts based on one or two columns, and then have the admin disable or change as needed. Similar to how reports are able to group. For example, I always need my sheets sorted by status: new/not started at the top and completed at the bottom, AND then by date assigned, newest on top, etc. As rows are marked as complete, or the status changes to 'hold' or 'in progress', the rows don't move automatically and the sheet starts to look very unorganized.
Also, with search (CNTRL+F search within the sheet, not the overall smartsheet search, which I do love!), I wish there was an easier way to just see the 3 or 4 items that come up when you search that selection, without having to create a whole filter or click next and click through all of them. I don't want to keep having to make filters that say 'show if order number equals 450629830', isolate those, do what I need to do, then delete or edit that filter again. It's just a really long process, having an option to 'view all' or something similar in search would be helpful.
Is it possible for your sorting requirement to be achieved just by creating/using sorted Reports, instead of regularly re-sorting the underlying Sheets themselves. In this way the Sheet becomes a more 'background' data store of task 'records' (rows) as they are added (using Forms?) to the top or bottom of the Sheet.
Reports are configurable to 'remember' up to 3 levels of sort by specified columns (and within Groups). A Report could also be configured to totally filter out the 'Completed' status items, or only ones that are overdue, etc.
I find using Reports more instead of relying so much on only Sheets is a better way to direct the users' work.
I agree with the above. The API seems like a lot of work. Heck - A workflow would work too - if I can default in a value, why can't I do an autosort that way as well?
Hi Serena, are you still looking for input on sorting? I would be happy to schedule some time. This is a needed feature not only for myself, but our internal customers are current struggling with this issue as we have multiple folks working in a shared sheet with different sorting needs. They are constantly resorting every time they refresh their view which is happening many times a day.
Hi Tom. Yes, I would still like to hear your thoughts on how you would like auto sorting to work. Please feel free to use thislinkto schedule some time. I look forward to hearing about your use cases in more detail.
2023-05-27T20:32:15.000+00:00","expand":["all","-body"],"excludeHiddenCategories":true,"type":"Idea"},"discussions":[{"discussionID":106969,"type":"idea","name":"Conditional Formatting for Dashboard Metric Widgets","excerpt":"When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard…","snippet":"When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric…","categoryID":349,"dateInserted":"2023-06-27T18:40:37+00:00","dateUpdated":"2023-06-27T19:26:00+00:00","dateLastComment":"2023-06-27T18:40:37+00:00","insertUserID":160171,"insertUser":{"userID":160171,"name":"GMichal","url":"https:\/\/community.smartsheet.com\/profile\/GMichal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T19:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":160171,"lastUserID":160171,"lastUser":{"userID":160171,"name":"GMichal","url":"https:\/\/community.smartsheet.com\/profile\/GMichal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T19:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":12,"score":2,"hot":3375785797,"url":"https:\/\/community.smartsheet.com\/discussion\/106969\/conditional-formatting-for-dashboard-metric-widgets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106969\/conditional-formatting-for-dashboard-metric-widgets","format":"Rich","tagIDs":[292,363,437],"lastPost":{"discussionID":106969,"name":"Conditional Formatting for Dashboard Metric Widgets","url":"https:\/\/community.smartsheet.com\/discussion\/106969\/conditional-formatting-for-dashboard-metric-widgets","dateInserted":"2023-06-27T18:40:37+00:00","insertUserID":160171,"insertUser":{"userID":160171,"name":"GMichal","url":"https:\/\/community.smartsheet.com\/profile\/GMichal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-27T19:24:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]},{"discussionID":106863,"type":"idea","name":"Add friends\/coworkers within the community","excerpt":"I would love to be able to add and follow friends within this community- is this already possible? Does this currently exist?","snippet":"I would love to be able to add and follow friends within this community- is this already possible? Does this currently exist?","categoryID":348,"dateInserted":"2023-06-24T00:04:38+00:00","dateUpdated":null,"dateLastComment":"2023-06-26T08:41:17+00:00","insertUserID":146478,"insertUser":{"userID":146478,"name":"malbers","title":"","url":"https:\/\/community.smartsheet.com\/profile\/malbers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/UWZGZGP18PK8\/nZFAGSNFMCT3V.jpg","dateLastActive":"2023-06-27T20:12:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-26T16:24:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":3,"hot":3375335455,"url":"https:\/\/community.smartsheet.com\/discussion\/106863\/add-friends-coworkers-within-the-community","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106863\/add-friends-coworkers-within-the-community","format":"Rich","tagIDs":[363],"lastPost":{"discussionID":106863,"commentID":382214,"name":"Re: Add friends\/coworkers within the community","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382214#Comment_382214","dateInserted":"2023-06-26T08:41:17+00:00","insertUserID":91566,"insertUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-06-26T16:24:30+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Community Platform Feedback","url":"https:\/\/community.smartsheet.com\/categories\/community-platform-feedback"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":348,"name":"Community Platform Feedback","url":"https:\/\/community.smartsheet.com\/categories\/community-platform-feedback","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":3}],"tags":[{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]},{"discussionID":106789,"type":"idea","name":"Limiting attachment access by license","excerpt":"I have run into a situation where I have confidential documents attached to a worksheet row that need to be available to certain personnel. These same worksheet rows are also accessed by personnel that should NOT have access to these documents. I already have hidden the attachment column, and several other columns that…","snippet":"I have run into a situation where I have confidential documents attached to a worksheet row that need to be available to certain personnel. These same worksheet rows are also…","categoryID":349,"dateInserted":"2023-06-22T17:27:25+00:00","dateUpdated":"2023-06-22T17:28:26+00:00","dateLastComment":"2023-06-26T18:06:18+00:00","insertUserID":162646,"insertUser":{"userID":162646,"name":"karlj","title":"Program Manager","url":"https:\/\/community.smartsheet.com\/profile\/karlj","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-22T17:27:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162646,"lastUserID":161565,"lastUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T18:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":25,"score":2,"hot":3375258823,"url":"https:\/\/community.smartsheet.com\/discussion\/106789\/limiting-attachment-access-by-license","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106789\/limiting-attachment-access-by-license","format":"Rich","tagIDs":[268,363],"lastPost":{"discussionID":106789,"commentID":382382,"name":"Re: Limiting attachment access by license","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382382#Comment_382382","dateInserted":"2023-06-26T18:06:18+00:00","insertUserID":161565,"insertUser":{"userID":161565,"name":"Courtney S.","url":"https:\/\/community.smartsheet.com\/profile\/Courtney%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-26T18:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Ideas & Feature Requests","url":"https:\/\/community.smartsheet.com\/categories\/ideas-%26-feature-requests"},{"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas"}],"groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"status":{"statusID":10000,"name":"Idea Submitted","state":"open","recordType":"discussion","recordSubType":"ideation"},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":2}],"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&dateInserted=%3E2023-05-27T20%3A32%3A15%2B00%3A00&type%5B0%5D=Idea&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser","prevURL":null,"currentPage":1,"total":145,"limit":3},"title":"Trending Ideas","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">