表

x.cells.length && x.cells[0].displayValue)…","categoryID":320,"dateInserted":"2023-02-02T02:02:31+00:00","dateUpdated":null,"dateLastComment":"2023-05-24T16:10:28+00:00","insertUserID":113904,"insertUser":{"userID":113904,"name":"Chris Shifflett","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20Shifflett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-02T13:10:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":1133,"lastUser":{"userID":1133,"name":"Gwen Rymill SBP","url":"https:\/\/community.smartsheet.com\/profile\/Gwen%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/09\/99\/n099985aff011cad70744a1fb676d6340.jpg","dateLastActive":"2023-06-05T13:36:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":true,"countComments":4,"countViews":292,"score":3,"hot":3360251279,"url":"https:\/\/community.smartsheet.com\/discussion\/100552\/dynamic-dropdowns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/100552\/dynamic-dropdowns","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-02-03T19:24:02+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":320,"name":"API & Developers","url":"https:\/\/community.smartsheet.com\/categories\/api-developers","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"}],"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}]},{"discussionID":101925,"type":"question","name":"Using an Automation to Duplicate a Row in the Same Sheet","excerpt":"I have read several posts that suggests that this is not currently an option. I have a sheet which contains a list of evaluations. Sometimes we have to complete a second, or even third evaluation of the same person. Each row represents a person and their evaluation. If we have to do a second evaluation then much of the…","categoryID":321,"dateInserted":"2023-03-01T14:50:48+00:00","dateUpdated":null,"dateLastComment":"2023-05-23T18:58:11+00:00","insertUserID":158182,"insertUser":{"userID":158182,"name":"Jeff Kline","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Kline","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-16T20:43:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":150489,"lastUser":{"userID":150489,"name":"johngraham78","url":"https:\/\/community.smartsheet.com\/profile\/johngraham78","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u4H1J4kiovI!pDlxaeN4qsI!19dZxKwmP8D","dateLastActive":"2023-05-30T21:35:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":303,"score":null,"hot":3362556539,"url":"https:\/\/community.smartsheet.com\/discussion\/101925\/using-an-automation-to-duplicate-a-row-in-the-same-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101925\/using-an-automation-to-duplicate-a-row-in-the-same-sheet","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-03-02T14:20:59+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":87222,"type":"question","name":"Auto Add\/Subtract to Inventory","excerpt":"I am attempting to create an inventory sheet for my business and was wondering if there is a function to automatically add and subtract to a number in a cell. Maybe something similar to say a button that +1 or -1 when clicked. If this is not available what would be the best way for my staff and I to updated inventory…","categoryID":322,"dateInserted":"2022-01-24T21:34:52+00:00","dateUpdated":null,"dateLastComment":"2023-05-23T17:43:49+00:00","insertUserID":144033,"insertUser":{"userID":144033,"name":"AJ Palmer","url":"https:\/\/community.smartsheet.com\/profile\/AJ%20Palmer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-18T20:25:39+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":146255,"lastUser":{"userID":146255,"name":"Dan Pollino","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Pollino","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xY1YccHv8mQ!pqdZ6dXevDo!qTIYmPwLNK0","dateLastActive":"2023-06-04T19:15:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":621,"score":null,"hot":3327928721,"url":"https:\/\/community.smartsheet.com\/discussion\/87222\/auto-add-subtract-to-inventory","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87222\/auto-add-subtract-to-inventory","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-27T15:28:09+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":334,"urlcode":"automations","name":"Automations"}],"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}]},{"discussionID":95838,"type":"question","name":"First Entry Flag equation as column formula?","excerpt":"Good morning! I'm trying to create a flag in my form receiver sheet to identify first entries vs. duplicates. This is to help me pull some metrics (counts) in other sheets. I have an equation that works row by row, but not in the very first row and also can't be converted to a column formula. What am I doing wrong? I'd…","categoryID":322,"dateInserted":"2022-09-23T10:43:11+00:00","dateUpdated":"2022-09-23T11:18:52+00:00","dateLastComment":"2023-05-23T16:29:17+00:00","insertUserID":152772,"insertUser":{"userID":152772,"name":"dorothy","url":"https:\/\/community.smartsheet.com\/profile\/dorothy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!A2ErX_e-vfs!x-vrMavlXvM!Z1460dBW0RQ","dateLastActive":"2022-10-06T17:50:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":152772,"lastUserID":139854,"lastUser":{"userID":139854,"name":"Jeffrey_PMO","url":"https:\/\/community.smartsheet.com\/profile\/Jeffrey_PMO","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/XT8S16OI62C0\/nWKBCT94431PG.jpg","dateLastActive":"2023-06-08T04:13:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":294,"score":null,"hot":3348792148,"url":"https:\/\/community.smartsheet.com\/discussion\/95838\/first-entry-flag-equation-as-column-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95838\/first-entry-flag-equation-as-column-formula","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/FGXGH9C9IK53\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-23T13:19:06+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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}]},{"discussionID":59196,"type":"question","name":"Formula to count of items in a multi dropdown list","excerpt":"Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…","categoryID":322,"dateInserted":"2019-10-03T10:51:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-05-23T09:24:05+00:00","insertUserID":19911,"insertUser":{"userID":19911,"name":"lcamacho19911","url":"https:\/\/community.smartsheet.com\/profile\/lcamacho19911","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-06\/62\/5f\/n625f7d47b44860124eba6b6cd2ab982e.jpg","dateLastActive":"2021-08-10T18:09:48+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-07T18:22:11+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":56,"countViews":45069,"score":0,"hot":3254967355,"url":"https:\/\/community.smartsheet.com\/discussion\/59196\/formula-to-count-of-items-in-a-multi-dropdown-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/59196\/formula-to-count-of-items-in-a-multi-dropdown-list","format":"Html","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-10\/89\/c4\/89c4ee3bed16ef499ac828ebb696cf59.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"colum with dropdown multiselect.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-11T13:46:23+00:00","dateAnswered":"2019-10-03T12:36:32+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":249,"urlcode":"Education","name":"Education"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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}]},{"discussionID":92207,"type":"idea","name":"Freeze Row","excerpt":"Enhancement request to add capability to freeze row (like freeze column)","categoryID":349,"dateInserted":"2022-06-15T16:45:48+00:00","dateUpdated":"2023-04-21T14:02:17+00:00","dateLastComment":"2023-05-23T08:49:53+00:00","insertUserID":95091,"insertUser":{"userID":95091,"name":"Sameer Karkhanis","url":"https:\/\/community.smartsheet.com\/profile\/Sameer%20Karkhanis","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!Gojd36hb2yQ!xWjdseh3KiQ!Pg1PywniI56","dateLastActive":"2022-10-07T00:55:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-08T00:53:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":19,"countViews":1169,"score":111,"hot":3340188041,"url":"https:\/\/community.smartsheet.com\/discussion\/92207\/freeze-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92207\/freeze-row","format":"Rich","groupID":null,"statusID":10003,"attributes":{"idea":{"statusNotes":"We love this idea! We are working on new freeze row and freeze column capabilities as part of our long-term planned enhancements for the grid experience.","statusID":10003,"status":{"name":"On Roadmap","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":366,"urlcode":"On Roadmap","name":"On Roadmap"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":105532,"type":"question","name":"Numbering Duplicates Based on a Date","excerpt":"Please see above a sheet for quote submissions, I want the revision number to automatically number the duplicates of service and contractor based on submission date with the oldest being revision number 1. Currently the Revision Number formula is: =IF(ISBLANK([Service + Contractor]@row), \"\", MATCH([Row ID]@row,…","categoryID":322,"dateInserted":"2023-05-22T15:42:08+00:00","dateUpdated":"2023-05-22T15:47:57+00:00","dateLastComment":"2023-05-23T08:25:49+00:00","insertUserID":158454,"insertUser":{"userID":158454,"name":"LindsayD","url":"https:\/\/community.smartsheet.com\/profile\/LindsayD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xCMlcTv7K4o!BmspAROmNLo!kT-l977J0_K","dateLastActive":"2023-06-06T08:56:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":158454,"lastUserID":158454,"lastUser":{"userID":158454,"name":"LindsayD","url":"https:\/\/community.smartsheet.com\/profile\/LindsayD","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xCMlcTv7K4o!BmspAROmNLo!kT-l977J0_K","dateLastActive":"2023-06-06T08:56:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":49,"score":null,"hot":3369601677,"url":"https:\/\/community.smartsheet.com\/discussion\/105532\/numbering-duplicates-based-on-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105532\/numbering-duplicates-based-on-a-date","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/U0CQAGT7WZAA\/screenshot-2023-05-22-at-16-40-04.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2023-05-22 at 16.40.04.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-23T08:24:58+00:00","dateAnswered":"2023-05-22T18:02:24+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":69190,"type":"question","name":"Restricted Dropdown - Find cells that don't comply","excerpt":"Hello All I am loving this community, it has helped me develop my sheets... so Thank you. This is my first discussion because I can't seem to find answer anywhere: I have sheet's with multiple dropdown columns on sheet that have restricted values. All these sheets feed other sheets with formulas so it is important to have…","categoryID":321,"dateInserted":"2020-06-17T08:58:25+00:00","dateUpdated":null,"dateLastComment":"2023-05-22T18:32:12+00:00","insertUserID":122751,"insertUser":{"userID":122751,"name":"Peter Graham","url":"https:\/\/community.smartsheet.com\/profile\/Peter%20Graham","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GulZX_GL1jw!AUDawA3-EXY!jMEl36XUfgl","dateLastActive":"2022-02-28T14:41:20+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-06-07T19:38:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":13,"countViews":926,"score":null,"hot":3277172437,"url":"https:\/\/community.smartsheet.com\/discussion\/69190\/restricted-dropdown-find-cells-that-dont-comply","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/69190\/restricted-dropdown-find-cells-that-dont-comply","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-05T17:32:32+00:00","dateAnswered":"2020-06-19T11:52:01+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}]},{"discussionID":103157,"type":"idea","name":"Automatically Sort Rows in Sheets","excerpt":"As rows get added & cell values change, it would 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.","categoryID":349,"dateInserted":"2023-03-24T22:28:51+00:00","dateUpdated":"2023-05-18T17:33:35+00:00","dateLastComment":"2023-05-22T16:05:23+00:00","insertUserID":157541,"insertUser":{"userID":157541,"name":"ro.fei","title":"","url":"https:\/\/community.smartsheet.com\/profile\/ro.fei","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4OWA5DDSR8JB\/n2H4UP1N6TZA6.jpg","dateLastActive":"2023-06-07T17:59:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"lastUserID":136300,"lastUser":{"userID":136300,"name":"Serena Batten","url":"https:\/\/community.smartsheet.com\/profile\/Serena%20Batten","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WSlr3iICM6M!6edr-kIKbjM!0gInk_3UpsF","dateLastActive":"2023-05-22T15:59:13+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":33,"countViews":1875,"score":99,"hot":3364517954,"url":"https:\/\/community.smartsheet.com\/discussion\/103157\/automatically-sort-rows-in-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103157\/automatically-sort-rows-in-sheets","format":"Rich","groupID":null,"statusID":10003,"attributes":{"idea":{"statusNotes":"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.","statusID":10003,"status":{"name":"On Roadmap","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":366,"urlcode":"On Roadmap","name":"On Roadmap"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":105150,"type":"discussion","name":"Limit increase: 100,000 inbound cell links for sheets","excerpt":"Hi Community, Say goodbye to a limit of 20,000 inbound cell links in sheets — now, all users on all plans can add up to 100,000 inbound cell links in their sheets, allowing you to consolidate information by linking cells between sheets. Stay tuned for more news about how Smartsheet is investing in scale and reliability.…","categoryID":335,"dateInserted":"2023-05-11T20:00:30+00:00","dateUpdated":null,"dateLastComment":"2023-05-21T04:27:07+00:00","insertUserID":145085,"insertUser":{"userID":145085,"name":"Allegra Silcox","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Allegra%20Silcox","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!btnWmx2hXT4!nevWPz3DEL4!dfcwT6jINFw","dateLastActive":"2023-06-02T03:20:24+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"updateUserID":null,"lastUserID":160225,"lastUser":{"userID":160225,"name":"Ken Armstrong","title":"Senior System Analyst (Smartsheet)","url":"https:\/\/community.smartsheet.com\/profile\/Ken%20Armstrong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4TVM7M4DTOJO\/nVLA4MQPFTIYO.jpg","dateLastActive":"2023-06-07T16:24:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":201,"score":7,"hot":3368484757,"url":"https:\/\/community.smartsheet.com\/discussion\/105150\/limit-increase-100-000-inbound-cell-links-for-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105150\/limit-increase-100-000-inbound-cell-links-for-sheets","format":"Rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":335,"name":"Product Announcements","url":"https:\/\/community.smartsheet.com\/categories\/product-announcements","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">