Marketing

) 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":83,"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-07-12T15:32:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":294,"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":62661,"type":"discussion","name":"Sheet Summary Report - Want to edit fields within report","excerpt":"I created a Sheet Summary Report, and have found that the fields within the report are not editable, unlike a Row Report. In a Row Report, I can click into the cell directly within the report and update it. On my Sheet Summary Report, the cells in report are locked down and uneditable. Am I missing something in order to be…","categoryID":321,"dateInserted":"2019-11-12T15:22:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-15T11:45:49+00:00","insertUserID":81206,"insertUser":{"userID":81206,"name":"Sara_Cook","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sara_Cook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/41\/f3\/n41f3c899bf54845305d58f18e6a1bd0b.jpg","dateLastActive":"2023-07-06T16:58:54+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"updateUserID":null,"lastUserID":81206,"lastUser":{"userID":81206,"name":"Sara_Cook","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sara_Cook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-11\/41\/f3\/n41f3c899bf54845305d58f18e6a1bd0b.jpg","dateLastActive":"2023-07-06T16:58:54+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":728,"score":1,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/62661\/sheet-summary-report-want-to-edit-fields-within-report","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62661\/sheet-summary-report-want-to-edit-fields-within-report","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-11\/2d\/fd\/2dfddfe38f8856ad77b3ec81896c48b1.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"My Projects Status Report.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"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-07-12T20:38:27+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":182,"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":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"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"}],"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":62061,"type":"discussion","name":"HELP writing a multi-variable IF Formula","excerpt":"Looking for some help with automating a Health column with Red, Yellow, Gray, Green balls based on 4 corresponding values in a Status drop-down. But there are also some overrides that I want to incorporate and can't figure out. Back Log = Gray In Progress = Yellow Flagged = Red Complete = Yellow Override 1 Marking…","categoryID":322,"dateInserted":"2019-11-05T14:30:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-07T11:25:50+00:00","insertUserID":109706,"insertUser":{"userID":109706,"name":"Balle053","url":"https:\/\/community.smartsheet.com\/profile\/Balle053","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-05T12:23:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":109706,"lastUser":{"userID":109706,"name":"Balle053","url":"https:\/\/community.smartsheet.com\/profile\/Balle053","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-05T12:23:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":73,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/62061\/help-writing-a-multi-variable-if-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62061\/help-writing-a-multi-variable-if-formula","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"}],"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":5966,"type":"discussion","name":"Sheet Roll-Up","excerpt":"I'm curious if there is a way to have a \"higher level\" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view of everything being worked on.","categoryID":318,"dateInserted":"2016-08-31T15:42:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-11-06T16:02:01+00:00","insertUserID":7077,"insertUser":{"userID":7077,"name":"Sarah Daily","url":"https:\/\/community.smartsheet.com\/profile\/Sarah%20Daily","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/ca\/e8\/ncae8d7a1e54f075a79af4967e59a3273.png","dateLastActive":"2018-04-19T09:58:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":105611,"lastUser":{"userID":105611,"name":"D@n","url":"https:\/\/community.smartsheet.com\/profile\/D%40n","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-05-03T22:25:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":15,"countViews":3962,"score":null,"hot":15,"url":"https:\/\/community.smartsheet.com\/discussion\/5966\/sheet-roll-up","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5966\/sheet-roll-up","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"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}">