Conditional Formatting

0.5, \"Red\", \"Green\") It compiles all the check boxes in my column from row 13 to 26,…","categoryID":318,"dateInserted":"2016-01-26T17:57:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-27T11:41:47+00:00","insertUserID":5231,"insertUser":{"userID":5231,"name":"Rob Peek","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20Peek","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-04-04T16:29:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":245,"lastUser":{"userID":245,"name":"JamesR","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JamesR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/87\/15\/n8715b9481d6c0836c04cd6097804bec6.jpg","dateLastActive":"2019-07-19T03:25:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":6,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/4034\/i-need-to-build-a-formula-that-looks-at-some-cells-in-a-column-but-not-all-of-them","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4034\/i-need-to-build-a-formula-that-looks-at-some-cells-in-a-column-but-not-all-of-them","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":3947,"type":"discussion","name":"Conditional Cell Linking","excerpt":"Hello, I could use some help on something I'm trying to do in SmartSheet. Scope of Project: I have a master inbound \"Lead Tracker\" sheet that I use to keep track of referrals sent in from various business partners. I would like for these business partners to have access to their own \"Lead Tracker\" as well which would…","categoryID":318,"dateInserted":"2016-01-17T17:39:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-27T10:23:23+00:00","insertUserID":5090,"insertUser":{"userID":5090,"name":"Ramsey Hamood","url":"https:\/\/community.smartsheet.com\/profile\/Ramsey%20Hamood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-02-11T10:10:41+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":3,"countViews":475,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/3947\/conditional-cell-linking","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3947\/conditional-cell-linking","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":472,"urlcode":"cell-linking","name":"Cell linking"},{"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":4012,"type":"discussion","name":"Default Symbol Labels","excerpt":"I am using standard symbols in a drop down box. They have the default lables 'Yes, No, Hold'. Is there a way to change these default labels within this sheet?","categoryID":318,"dateInserted":"2016-01-24T08:25:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-26T17:22:46+00:00","insertUserID":2371,"insertUser":{"userID":2371,"name":"Bill Lafferty","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Bill%20Lafferty","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/fe\/n74fe5eb2bc95a9dcea58597f1b81c2de.jpg","dateLastActive":"2023-05-04T19:25:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":2371,"lastUser":{"userID":2371,"name":"Bill Lafferty","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Bill%20Lafferty","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/fe\/n74fe5eb2bc95a9dcea58597f1b81c2de.jpg","dateLastActive":"2023-05-04T19:25:16+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":1241,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/4012\/default-symbol-labels","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4012\/default-symbol-labels","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":208,"urlcode":"Workspaces","name":"Workspaces"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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":4016,"type":"discussion","name":"Can I give the RYGB Balls column \"Status\" a default colour when a new row is added to the sheet?","excerpt":"I think my question speaks for itself. The RYGB balls type has 4 coloured balls. Which I'm using as follows. Blue = \"New task\" Green = \"Active task\" Red = \"Finished task\" Yellow = I'm not using this one. So what I want is for a new row in the sheet, is for this column to automatically turn \"Blue\" to indicate a new task. It…","categoryID":318,"dateInserted":"2016-01-25T04:13:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-25T15:17:46+00:00","insertUserID":5202,"insertUser":{"userID":5202,"name":"System Admin","url":"https:\/\/community.smartsheet.com\/profile\/System%20Admin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-25T03:50:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":245,"lastUser":{"userID":245,"name":"JamesR","title":"","url":"https:\/\/community.smartsheet.com\/profile\/JamesR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/87\/15\/n8715b9481d6c0836c04cd6097804bec6.jpg","dateLastActive":"2019-07-19T03:25:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":31,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/4016\/can-i-give-the-rygb-balls-column-status-a-default-colour-when-a-new-row-is-added-to-the-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4016\/can-i-give-the-rygb-balls-column-status-a-default-colour-when-a-new-row-is-added-to-the-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"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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":3972,"type":"discussion","name":"Merging inventory","excerpt":"I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is what I actually have on hand in the warehouse the second sheet is what our system says we should have. So far very simple.…","categoryID":318,"dateInserted":"2016-01-19T16:36:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-21T18:12:21+00:00","insertUserID":5133,"insertUser":{"userID":5133,"name":"Steve Lilgreen","url":"https:\/\/community.smartsheet.com\/profile\/Steve%20Lilgreen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-19T16:34:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":3133,"lastUser":{"userID":3133,"name":"John Hammond","url":"https:\/\/community.smartsheet.com\/profile\/John%20Hammond","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-10-05T12:12:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":13,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/3972\/merging-inventory","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3972\/merging-inventory","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":207,"urlcode":"Sales","name":"Sales"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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":3694,"type":"discussion","name":"Automating Harvey Balls based on RAG status","excerpt":"Hi, Could somoen please help with the formula I need to use to automate completion of Harvey Balls based on RAG status of four phases? I am using RAG status balls (Green, Yellow, Red and Blue) to indicate status of each phase of the implementation. I have four implementation phases and basically want the Harvey Balls to Go…","categoryID":317,"dateInserted":"2015-12-03T11:19:44+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-21T15:42:10+00:00","insertUserID":4500,"insertUser":{"userID":4500,"name":"Dagmara Aldridge","url":"https:\/\/community.smartsheet.com\/profile\/Dagmara%20Aldridge","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-07T09:06:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":12,"countViews":285,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/3694\/automating-harvey-balls-based-on-rag-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3694\/automating-harvey-balls-based-on-rag-status","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":3935,"type":"discussion","name":"Conditional Formatting","excerpt":"I have a question that someone may be able to help me with. If I have a column called Finish Date. On line 5 - I enter a date that my customer wants project to be finished On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed…","categoryID":318,"dateInserted":"2016-01-14T22:09:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-17T22:09:02+00:00","insertUserID":1386,"insertUser":{"userID":1386,"name":"Kathy Coulthard","url":"https:\/\/community.smartsheet.com\/profile\/Kathy%20Coulthard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-06T18:02:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":1386,"lastUser":{"userID":1386,"name":"Kathy Coulthard","url":"https:\/\/community.smartsheet.com\/profile\/Kathy%20Coulthard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-06T18:02:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":51,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/3935\/conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3935\/conditional-formatting","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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"tagID":281,"urlcode":"Support","name":"Support"},{"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":3894,"type":"discussion","name":"Looking for help with this","excerpt":"I am looking to build a sheet to compare rates from energy suppliers. there are a number of dependent factors which need to built in to the sheet which I dont know how to do. Can anyone help me please John","categoryID":318,"dateInserted":"2016-01-10T08:08:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-10T22:30:22+00:00","insertUserID":4733,"insertUser":{"userID":4733,"name":"John Thompson","url":"https:\/\/community.smartsheet.com\/profile\/John%20Thompson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-12-21T09:29:53+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":3,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/3894\/looking-for-help-with-this","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3894\/looking-for-help-with-this","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}">