制造业

讨论表

) 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":85,"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-13T15:13:30+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":290,"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">