Conditional Formatting

Baseline2, 1, 1) Finish2 = the first cell with the actual finish date Baseline2 =…","categoryID":318,"dateInserted":"2016-05-04T05:32:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-05-04T11:22:48+00:00","insertUserID":6531,"insertUser":{"userID":6531,"name":"Cliffinkent","url":"https:\/\/community.smartsheet.com\/profile\/Cliffinkent","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-05-04T04:43:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6531,"lastUser":{"userID":6531,"name":"Cliffinkent","url":"https:\/\/community.smartsheet.com\/profile\/Cliffinkent","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-05-04T04:43:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":455,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/4932\/conditional-formatting-target-dates-vs-actual-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4932\/conditional-formatting-target-dates-vs-actual-dates","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":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":4846,"type":"discussion","name":"Multiple currency columns thousands separators","excerpt":"We have a sheet with multiple currency columns, EUR, GBP, AUD etc. Is there a way to define thousands markers? Currently it seems to be defined by user account setting, which does not work for us as we need EUR with \"dot\" separators and AUD with comma separators.","categoryID":318,"dateInserted":"2016-04-25T09:27:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-25T09:43:11+00:00","insertUserID":6397,"insertUser":{"userID":6397,"name":"Xavier Butcher","url":"https:\/\/community.smartsheet.com\/profile\/Xavier%20Butcher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-25T09:24:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"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":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/4846\/multiple-currency-columns-thousands-separators","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4846\/multiple-currency-columns-thousands-separators","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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":4791,"type":"discussion","name":"Changing column to a \"List\"","excerpt":"I have a column that has equipment in it, it is set up as a text column. I am using the information in that column for conditional formating. Now I want to make that column a list to choose from and I can't because of the conditional formating. Do I have to un-do all the conditional formating to change it to a list column…","categoryID":318,"dateInserted":"2016-04-18T12:44:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-25T08:03:38+00:00","insertUserID":6279,"insertUser":{"userID":6279,"name":"Heidi Decker","url":"https:\/\/community.smartsheet.com\/profile\/Heidi%20Decker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T11:25:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":6279,"lastUser":{"userID":6279,"name":"Heidi Decker","url":"https:\/\/community.smartsheet.com\/profile\/Heidi%20Decker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T11:25:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":1,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/4791\/changing-column-to-a-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4791\/changing-column-to-a-list","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":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":4643,"type":"discussion","name":"If and checkbox","excerpt":" I have used th IF equation and the checkbox and I want it to copy a value from another cell when the checkbox is checked. Until here I am ok. However I want it to apply the number \"0\" (zero) when the check box is unchecked. can anybody help me please? Thank you. ","categoryID":318,"dateInserted":"2016-04-03T17:42:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-25T05:21:48+00:00","insertUserID":6102,"insertUser":{"userID":6102,"name":"Dimitris Papandreou","url":"https:\/\/community.smartsheet.com\/profile\/Dimitris%20Papandreou","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-04T16:06:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"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":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":18,"countViews":2971,"score":null,"hot":18,"url":"https:\/\/community.smartsheet.com\/discussion\/4643\/if-and-checkbox","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4643\/if-and-checkbox","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":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":4840,"type":"discussion","name":"% complete value not adjusting start date of next task","excerpt":"Hello I am hoping someone can help please, here is my problem I have a few tasks, dependent on each other - D is dependent on C, C is dependent on B, B is dependent on A etc etc. I have a complete tick box for them and also a % complete column Task A is complete, Task B is 40% complete, Task C is still showing it starting…","categoryID":318,"dateInserted":"2016-04-24T13:09:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-24T13:24:25+00:00","insertUserID":6392,"insertUser":{"userID":6392,"name":"Alan Russell","url":"https:\/\/community.smartsheet.com\/profile\/Alan%20Russell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-28T22:26:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"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":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":4,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/4840\/complete-value-not-adjusting-start-date-of-next-task","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4840\/complete-value-not-adjusting-start-date-of-next-task","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":218,"urlcode":"Construction","name":"Construction"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":4775,"type":"discussion","name":"Very strange formatting issue","excerpt":"In my sheet, I keep my primary column font color \"Red\" until we take the first action. At that time I manually change the color to \"Black\". I do not have any conditional formatting that has any control over that column. I do have other columns that do have conditional formatting controlling them. Here is the strange part..…","categoryID":318,"dateInserted":"2016-04-15T09:48:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-19T14:36:01+00:00","insertUserID":6279,"insertUser":{"userID":6279,"name":"Heidi Decker","url":"https:\/\/community.smartsheet.com\/profile\/Heidi%20Decker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T11:25:39+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":6255,"lastUser":{"userID":6255,"name":"Dave D","url":"https:\/\/community.smartsheet.com\/profile\/Dave%20D","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-05-12T14:30:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":100,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/4775\/very-strange-formatting-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4775\/very-strange-formatting-issue","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":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":4699,"type":"discussion","name":"Clear Cells if Time Is","excerpt":"Hi, I'm looking for a formula to clear the contents of a column daily (preferably at a specfiic time). To give you an idea of what it is being used for; My sheet has a list of contacts and a yes or no checkbox column. Every day at a certain time an update request is sent out to all contacts listed asking \"will you be…","categoryID":318,"dateInserted":"2016-04-08T11:04:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-11T17:18:58+00:00","insertUserID":5661,"insertUser":{"userID":5661,"name":"A O","url":"https:\/\/community.smartsheet.com\/profile\/A%20O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-08T10:52:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":5661,"lastUser":{"userID":5661,"name":"A O","url":"https:\/\/community.smartsheet.com\/profile\/A%20O","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-08T10:52:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":135,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/4699\/clear-cells-if-time-is","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4699\/clear-cells-if-time-is","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":247,"urlcode":"Contacts","name":"Contacts"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"real-estate","name":"Real Estate"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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":4685,"type":"discussion","name":"Locking a row when a check box is selected","excerpt":"Is it possible to have a row \"lock\" when someone selects the \"check box\" column, so they (Editors) can not change data on that row? ","categoryID":318,"dateInserted":"2016-04-07T12:34:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-04-08T19:01:28+00:00","insertUserID":6169,"insertUser":{"userID":6169,"name":"Teia Hall-Fast","url":"https:\/\/community.smartsheet.com\/profile\/Teia%20Hall-Fast","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-04-07T12:30:06+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":180,"lastUser":{"userID":180,"name":"JohnHinkle","url":"https:\/\/community.smartsheet.com\/profile\/JohnHinkle","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-05-10T14:48:48+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":188,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/4685\/locking-a-row-when-a-check-box-is-selected","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4685\/locking-a-row-when-a-check-box-is-selected","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":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}">