Manufacturing

) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…","categoryID":321,"dateInserted":"2019-11-20T10:26:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-20T14:22:15+00:00","insertUserID":111106,"insertUser":{"userID":111106,"name":"Kristina Howes","url":"https:\/\/community.smartsheet.com\/profile\/Kristina%20Howes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-11T17:10:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":111106,"lastUser":{"userID":111106,"name":"Kristina Howes","url":"https:\/\/community.smartsheet.com\/profile\/Kristina%20Howes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-11T17:10:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":84,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/63446\/how-to-keep-cell-unchanged-in-status-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63446\/how-to-keep-cell-unchanged-in-status-column","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":62771,"type":"discussion","name":"Nested If with Multiple Conditions Automation for Project Management","excerpt":"Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)=\"Complete\"), ([Status]@row)= \"In Progress\"),\"On Deck\", \"Not Started\") I just…","categoryID":322,"dateInserted":"2019-11-13T13:07:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-19T10:34:57+00:00","insertUserID":111106,"insertUser":{"userID":111106,"name":"Kristina Howes","url":"https:\/\/community.smartsheet.com\/profile\/Kristina%20Howes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-11T17:10:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T21:15:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":293,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/62771\/nested-if-with-multiple-conditions-automation-for-project-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62771\/nested-if-with-multiple-conditions-automation-for-project-management","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":241,"urlcode":"calendar","name":"Calendar View"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":63121,"type":"discussion","name":"Best way of Counting a given number of States","excerpt":"Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linking and doing some calculations on it in an extra sheet. As it turns out now, doing all of this \"manually\" for multiple…","categoryID":321,"dateInserted":"2019-11-18T08:17:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-18T10:21:25+00:00","insertUserID":111601,"insertUser":{"userID":111601,"name":"Raste","url":"https:\/\/community.smartsheet.com\/profile\/Raste","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!gvPXHzswuPw!nCDXH69ZC-Y!nPPbUxjd_xZ","dateLastActive":"2020-02-12T14:05:36+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":134,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/63121\/best-way-of-counting-a-given-number-of-states","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/63121\/best-way-of-counting-a-given-number-of-states","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/d8\/ce\/d8cea98c84bbf31fc8953080d0dd8433.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"example.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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}]},{"discussionID":62956,"type":"discussion","name":"Gantt View Timeline Zoom","excerpt":"I want to be able to view my gantt chart more zoomed in. Is it possible for me to have my primary headings as days and secondary as hours? Or is the furthest you can zoom in weeks and days?","categoryID":321,"dateInserted":"2019-11-14T18:13:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-15T04:43:41+00:00","insertUserID":111376,"insertUser":{"userID":111376,"name":"Mjfreuland","url":"https:\/\/community.smartsheet.com\/profile\/Mjfreuland","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-14T18:08:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":164,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/62956\/gantt-view-timeline-zoom","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62956\/gantt-view-timeline-zoom","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}],"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":62871,"type":"discussion","name":"Sharing Report to non-licensed users","excerpt":"HI, I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users. Before we signed up to the paid account this was an option. Thanks, David ","categoryID":321,"dateInserted":"2019-11-14T11:52:16+00:00","dateUpdated":"2020-06-11T14:50:07+00:00","dateLastComment":"2019-11-14T12:37:53+00:00","insertUserID":101356,"insertUser":{"userID":101356,"name":"DavidHB","url":"https:\/\/community.smartsheet.com\/profile\/DavidHB","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-16T14:57:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":276,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/62871\/sharing-report-to-non-licensed-users","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62871\/sharing-report-to-non-licensed-users","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":62436,"type":"discussion","name":"Automatically update form link when creating new folders","excerpt":"Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and does not change when I copy the folder template and make a new project. Is there a way…","categoryID":321,"dateInserted":"2019-11-09T22:48:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-13T14:20:54+00:00","insertUserID":100956,"insertUser":{"userID":100956,"name":"Devan Hutchens","url":"https:\/\/community.smartsheet.com\/profile\/Devan%20Hutchens","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-23T20:22:47+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-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":246,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/62436\/automatically-update-form-link-when-creating-new-folders","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62436\/automatically-update-form-link-when-creating-new-folders","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":62551,"type":"discussion","name":"Project Approval Received \/ Master Project Sheet Populated","excerpt":"I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review\/approval\/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…","categoryID":322,"dateInserted":"2019-11-11T23:06:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-12T08:58:59+00:00","insertUserID":77966,"insertUser":{"userID":77966,"name":"Brad Huff","url":"https:\/\/community.smartsheet.com\/profile\/Brad%20Huff","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!hAleYfQQJzo!kmdcH1B4cjw!ieS0yJrcV6Q","dateLastActive":"2020-01-16T19:22:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":184,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/62551\/project-approval-received-master-project-sheet-populated","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62551\/project-approval-received-master-project-sheet-populated","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":271,"urlcode":"services","name":"Services"},{"tagID":274,"urlcode":"legal","name":"Legal"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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}">