Formulas

30,\"Red\",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),\"Yellow\", IF(OR(TODAY-[INVOICE DUE…","categoryID":318,"dateInserted":"2016-08-19T06:58:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-19T16:38:59+00:00","insertUserID":7893,"insertUser":{"userID":7893,"name":"Ladislav","url":"https:\/\/community.smartsheet.com\/profile\/Ladislav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-19T16:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7893,"lastUser":{"userID":7893,"name":"Ladislav","url":"https:\/\/community.smartsheet.com\/profile\/Ladislav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-19T16:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":81,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5855\/nested-if-formula-using-additional-and-or-logical-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5855\/nested-if-formula-using-additional-and-or-logical-functions","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":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":271,"urlcode":"services","name":"Services"}],"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":5803,"type":"discussion","name":"Color parent row while any children rows becomes red","excerpt":"How may we construct a formula so that a parent row will be highlighted in red, if any of its children row becomes highlighted in red color? Thank you. Jon","categoryID":318,"dateInserted":"2016-08-12T00:54:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-19T14:08:41+00:00","insertUserID":7908,"insertUser":{"userID":7908,"name":"Jonathan Chan","url":"https:\/\/community.smartsheet.com\/profile\/Jonathan%20Chan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-12T00:43:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":157,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/5803\/color-parent-row-while-any-children-rows-becomes-red","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5803\/color-parent-row-while-any-children-rows-becomes-red","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":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":5852,"type":"discussion","name":"Countif with wildcard","excerpt":"Need some ideas how to count number of cells in a range with any text in them. The formula below returns 0 (when all cells in the range contain text) =COUNTIF(Column Name]10:[Column Name]19, \"*\") Any ideas for text wildcard? Thanks","categoryID":318,"dateInserted":"2016-08-18T12:59:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-18T17:13:37+00:00","insertUserID":6214,"insertUser":{"userID":6214,"name":"Nichole Robillard","url":"https:\/\/community.smartsheet.com\/profile\/Nichole%20Robillard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-18T12:54:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6214,"lastUser":{"userID":6214,"name":"Nichole Robillard","url":"https:\/\/community.smartsheet.com\/profile\/Nichole%20Robillard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-18T12:54:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":359,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5852\/countif-with-wildcard","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5852\/countif-with-wildcard","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":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":5819,"type":"discussion","name":"Incorporate two data sets in one if\/sum statement.","excerpt":"I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%. I want the Sum column to show a total value anytime the % Complete is less than 100%.","categoryID":318,"dateInserted":"2016-08-15T17:34:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-18T17:11:38+00:00","insertUserID":4680,"insertUser":{"userID":4680,"name":"Razmig Varsam","url":"https:\/\/community.smartsheet.com\/profile\/Razmig%20Varsam","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-15T17:29:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4680,"lastUser":{"userID":4680,"name":"Razmig Varsam","url":"https:\/\/community.smartsheet.com\/profile\/Razmig%20Varsam","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-15T17:29:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":22,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/5819\/incorporate-two-data-sets-in-one-if-sum-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5819\/incorporate-two-data-sets-in-one-if-sum-statement","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/23\/da\/23da88e44dacfe95aad08a899a1f58e2.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"8-15-2016 2-31-45 PM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"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":5829,"type":"discussion","name":"Can the IF() formula use a conditional test from a different sheet?","excerpt":"..or does the test have to be within the same sheet?","categoryID":318,"dateInserted":"2016-08-16T13:53:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-18T16:57:42+00:00","insertUserID":7819,"insertUser":{"userID":7819,"name":"Dave the Banker","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20the%20Banker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-07T16:21:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":1,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/5829\/can-the-if-formula-use-a-conditional-test-from-a-different-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5829\/can-the-if-formula-use-a-conditional-test-from-a-different-sheet","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":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":5831,"type":"discussion","name":"Create dependency reminder by date","excerpt":"I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for \"publish date\", once 6 months have passed since that date, I'd like a status column with options of \"current, needs review, outdated\" to reflect status…","categoryID":318,"dateInserted":"2016-08-16T21:48:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-18T14:38:42+00:00","insertUserID":7943,"insertUser":{"userID":7943,"name":"Greg Welch","url":"https:\/\/community.smartsheet.com\/profile\/Greg%20Welch","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-16T20:21:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2677,"lastUser":{"userID":2677,"name":"Kennedy Stomps","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Kennedy%20Stomps","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/5d\/7b\/n5d7b4f0582903f4af0de71e9360f57fa.jpg","dateLastActive":"2019-11-15T14:32:22+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/5831\/create-dependency-reminder-by-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5831\/create-dependency-reminder-by-date","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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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}]},{"discussionID":5837,"type":"discussion","name":"Calculate a whole number with a remainder","excerpt":"Hey All, I have a column that calculates the time a vehicle is in our fleet. It returns a whole number such as 500 days. Is there a formula that will convert that to number of years with a remainder being the number of days. (1 year 135 days). Any help is much appreciated. Thanks Dwayne","categoryID":318,"dateInserted":"2016-08-17T11:42:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-17T18:43:37+00:00","insertUserID":7953,"insertUser":{"userID":7953,"name":"Dwayne Anjewierden","url":"https:\/\/community.smartsheet.com\/profile\/Dwayne%20Anjewierden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-17T11:37:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7953,"lastUser":{"userID":7953,"name":"Dwayne Anjewierden","url":"https:\/\/community.smartsheet.com\/profile\/Dwayne%20Anjewierden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-17T11:37:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":5,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5837\/calculate-a-whole-number-with-a-remainder","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5837\/calculate-a-whole-number-with-a-remainder","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":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":5827,"type":"discussion","name":"Feature Request: JOIN argument range","excerpt":"Slightly related to: https:\/\/community.smartsheet.com\/discussion\/release-2016-08-06-formula-argument-declaration-confusion JOIN appears to be \"vertically-centric\", that is, designed more for joining text from a vertical range instead of a horizontal one. I would like to cherry pick cells from the current row to JOIN into a…","categoryID":318,"dateInserted":"2016-08-16T09:38:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-16T22:49:07+00:00","insertUserID":4374,"insertUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":391,"lastUser":{"userID":391,"name":"John Sauber","title":"","url":"https:\/\/community.smartsheet.com\/profile\/John%20Sauber","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/18\/38\/n18381cdb6f38bc6b446fd26a96bafc25.jpg","dateLastActive":"2023-06-26T12:44:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":198,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/5827\/feature-request-join-argument-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5827\/feature-request-join-argument-range","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":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":1638,"type":"discussion","name":"How to set up a departmental time off request sheet?","excerpt":"I was wondering how I could set up a document that is one sheet for time off. The main things we need are a form or something to fill out that will go to the employees specific manager to approve or deny, and will then notify the employee if it has been denied or approved, and if approved, will then populate in the sheet…","categoryID":317,"dateInserted":"2015-07-24T14:51:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-16T14:38:33+00:00","insertUserID":2678,"insertUser":{"userID":2678,"name":"NHI","url":"https:\/\/community.smartsheet.com\/profile\/NHI","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-07-24T14:46:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7721,"lastUser":{"userID":7721,"name":"Tony Davidson - SmartSheet Certified User 2016","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Davidson%20-%20SmartSheet%20Certified%20User%202016","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-23T15:04:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":11,"countViews":836,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/1638\/how-to-set-up-a-departmental-time-off-request-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/1638\/how-to-set-up-a-departmental-time-off-request-sheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":241,"urlcode":"calendar","name":"Calendar View"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"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":5808,"type":"discussion","name":"Prevent Check Box formula from erasing when check-box is manually checked by accident.","excerpt":"In below scenario, check box formula disappears when the cell is checked manually by accident. Is there a way to prevent check-box-formula from being erased when the check box is manually checked? • Pls refer to attached picture “Query - Check Box Formula” for check box formula used. Thank you. Jon","categoryID":318,"dateInserted":"2016-08-12T02:29:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-15T22:59:25+00:00","insertUserID":7908,"insertUser":{"userID":7908,"name":"Jonathan Chan","url":"https:\/\/community.smartsheet.com\/profile\/Jonathan%20Chan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-12T00:43:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7908,"lastUser":{"userID":7908,"name":"Jonathan Chan","url":"https:\/\/community.smartsheet.com\/profile\/Jonathan%20Chan","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-12T00:43:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":79,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5808\/prevent-check-box-formula-from-erasing-when-check-box-is-manually-checked-by-accident","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5808\/prevent-check-box-formula-from-erasing-when-check-box-is-manually-checked-by-accident","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/ec\/07\/ec0782075b1466fe1242901aa6f1cf17.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Query - Check Box Formula.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">