Automated Sort in Sheet
Is it possible to create an automation that sorts the rows automatically when changes are saved?
For example, if my sheet is sorted by Column "Stage" Numerically Increasing, and I insert a row, fill it in, and save it, I want the sheet to re-sort to incorporate that added row in its proper location.
Thank you!
Best Answer
-
Paul Newcome ✭✭✭✭✭✭There is no way to do this within a Sheet. You can however use a report which does auto-sort and a form to add new rows with both placed on a dashboard.
Answers
-
Paul Newcome ✭✭✭✭✭✭
There is no way to do this within a Sheet. You can however use a report which does auto-sort and a form to add new rows with both placed on a dashboard.
Categories
You can see when the last run occurred, but not a list of runs. <\/p>
Click Automation - Manage Workflows<\/p><\/div><\/div>
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/E3SK6GNMQ546\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nThe \"Last ran\" date and time is displayed.<\/p>
BRgds,<\/p>
-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":112019,"type":"question","name":"Change Dates w\/ CNT F","excerpt":"I can't seem to use the \"CTRL F\" function to change the years in the dates columns. For instance, I want to change Dec 25, 2023 to Dec 25, 2024. All I need to change is \"2023\" to \"2024\". Nothing seems to bring up the Dec 25, 2023 date no matter how I search. Can someone please let me know how to find such dates and then…","snippet":"I can't seem to use the \"CTRL F\" function to change the years in the dates columns. For instance, I want to change Dec 25, 2023 to Dec 25, 2024. All I need to change is \"2023\" to…","categoryID":321,"dateInserted":"2023-10-23T15:47:28+00:00","dateUpdated":null,"dateLastComment":"2023-10-24T15:45:06+00:00","insertUserID":140966,"insertUser":{"userID":140966,"name":"DieHard Jets","url":"https:\/\/community.smartsheet.com\/profile\/DieHard%20Jets","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqNr_7IPH7s!7YEoe-ZaUvs!GnmHpUESlnd","dateLastActive":"2023-10-24T15:03:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-10-25T13:58:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":38,"score":null,"hot":3396241354,"url":"https:\/\/community.smartsheet.com\/discussion\/112019\/change-dates-w-cnt-f","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112019\/change-dates-w-cnt-f","format":"Rich","lastPost":{"discussionID":112019,"commentID":401406,"name":"Re: Change Dates w\/ CNT F","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401406#Comment_401406","dateInserted":"2023-10-24T15:45:06+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-10-25T13:58:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-24T15:04:14+00:00","dateAnswered":"2023-10-24T13:03:33+00:00","acceptedAnswers":[{"commentID":401333,"body":"
You will need to enter the full date in the search and have it replace with a full date.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":112009,"type":"question","name":"Manufacturing Facility Relocation Template","excerpt":"Does anyone know of a template for managing a Manufacturing Site Relocation?","snippet":"Does anyone know of a template for managing a Manufacturing Site Relocation?","categoryID":321,"dateInserted":"2023-10-23T13:43:35+00:00","dateUpdated":null,"dateLastComment":"2023-10-24T13:24:35+00:00","insertUserID":43656,"insertUser":{"userID":43656,"name":"amcintyre","url":"https:\/\/community.smartsheet.com\/profile\/amcintyre","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-10-25T14:52:18+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-10-25T18:07:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3396223090,"url":"https:\/\/community.smartsheet.com\/discussion\/112009\/manufacturing-facility-relocation-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112009\/manufacturing-facility-relocation-template","format":"Rich","tagIDs":[211,215],"lastPost":{"discussionID":112009,"commentID":401345,"name":"Re: Manufacturing Facility Relocation Template","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/401345#Comment_401345","dateInserted":"2023-10-24T13:24:35+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-10-25T18:07:23+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-25T14:52:41+00:00","dateAnswered":"2023-10-24T13:24:35+00:00","acceptedAnswers":[{"commentID":401345,"body":"
Hey @amcintyre<\/a> <\/p> I don't know if there's a template that specifically matches what you need, but you could try downloading some of the more generic templates or template sets and use them as a starting point. <\/p> For example:<\/p> Cheers,<\/p> Genevieve<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":215,"urlcode":"templates","name":"Templates"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5195,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
