BMar✭

0 then apply... 2. Allow selecting multiple columns to apply formatting. It's super annoying to clone a rule several times to highlight multiple columns.…","categoryID":318,"dateInserted":"2016-11-09T12:14:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-14T11:23:23+00:00","insertUserID":8754,"insertUser":{"userID":8754,"name":"BMar","url":"https:\/\/community.smartsheet.com\/profile\/BMar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-19T11:22:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":2873,"lastUser":{"userID":2873,"name":"Claire Diener","url":"https:\/\/community.smartsheet.com\/profile\/Claire%20Diener","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-01\/41\/86\/n4186ba594c2fe174b341823535e3bece.jpg","dateLastActive":"2019-06-19T17:17:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":13,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/6499\/conditional-formatting-enhancement-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6499\/conditional-formatting-enhancement-requests","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":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}]},{"discussionID":6478,"type":"discussion","name":"Referencing checked state of Flag symbol using formula","excerpt":"I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time. In a Due Date column I use a formula to add 7 days to the Received Date. I want to change the formula so that it adds only 5 days IF the flag is checked. I can't seem to find out how to reference the value of the flag cell, though.…","categoryID":318,"dateInserted":"2016-11-07T09:50:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-11-07T17:45:50+00:00","insertUserID":8754,"insertUser":{"userID":8754,"name":"BMar","url":"https:\/\/community.smartsheet.com\/profile\/BMar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-19T11:22:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":1487,"lastUser":{"userID":1487,"name":"Atus Bartal","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Atus%20Bartal","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/44\/n9b44bb622408f3a1eae0cfe237eb7758.jpg","dateLastActive":"2019-10-04T04:22:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":199,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6478\/referencing-checked-state-of-flag-symbol-using-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6478\/referencing-checked-state-of-flag-symbol-using-formula","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":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":6347,"type":"discussion","name":"View\/Comment Only?","excerpt":"I'd like to allow people to view my sheet and comment on tasks without being able to make any other edits. It would be great to have more specific control of user permissions to make this possible. Maybe somebody has a creative way to do this with sharing\/publishing?","categoryID":318,"dateInserted":"2016-10-20T14:03:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-10-25T15:16:21+00:00","insertUserID":8754,"insertUser":{"userID":8754,"name":"BMar","url":"https:\/\/community.smartsheet.com\/profile\/BMar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-10-19T11:22:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8376,"lastUser":{"userID":8376,"name":"Laddavanh Mantryvong","url":"https:\/\/community.smartsheet.com\/profile\/Laddavanh%20Mantryvong","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-10\/e0\/fd\/ne0fd26df828ff6bf0218ed46c0b7c9e3.jpg","dateLastActive":"2018-10-24T10:11:53+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":466,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/6347\/view-comment-only","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6347\/view-comment-only","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":223,"urlcode":"Publish","name":"Publish"},{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":441,"urlcode":"comments-and-conversations","name":"Comments and Conversations"}],"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":false,"noCheckboxes":true}">