制造业

) 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-06-05T20:57:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":287,"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-06-05T13:34:00+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":135,"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">