条件格式

10, \"Green\", IF(AND([Committed Closure Date]@row - TODAY() >= 6, [Committed Closure Date]@row…","categoryID":322,"dateInserted":"2023-04-25T17:11:43+00:00","dateUpdated":null,"dateLastComment":"2023-04-26T13:47:58+00:00","insertUserID":159525,"insertUser":{"userID":159525,"name":"Dami","url":"https:\/\/community.smartsheet.com\/profile\/Dami","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-27T15:25:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159525,"lastUser":{"userID":159525,"name":"Dami","url":"https:\/\/community.smartsheet.com\/profile\/Dami","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-27T15:25:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":48,"score":null,"hot":3364960781,"url":"https:\/\/community.smartsheet.com\/discussion\/104445\/using-if-and-isbank-please-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104445\/using-if-and-isbank-please-help","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-26T08:03:26+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":104473,"type":"question","name":"How do I update the Parent Cell so that anytime one of the candidates (listed in the Child Cells)...","excerpt":"is marked as \"Hired\" as the Status, it then doesn't count that row? For reference, see the first Parent Column \"Accounting - 3 Openings\" - however, there is only 1 opening that doesn't have the status as hired and it's not showing that...I tried to add conditional formatting to change the row to \"Green\" if status is Hired…","categoryID":322,"dateInserted":"2023-04-25T23:30:53+00:00","dateUpdated":null,"dateLastComment":"2023-04-26T07:43:43+00:00","insertUserID":160884,"insertUser":{"userID":160884,"name":"Destiny Q","title":"Vice President, Talent Acquisition","url":"https:\/\/community.smartsheet.com\/profile\/Destiny%20Q","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-04-26T21:20:04+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-06-05T09:50:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":16,"score":null,"hot":3364961076,"url":"https:\/\/community.smartsheet.com\/discussion\/104473\/how-do-i-update-the-parent-cell-so-that-anytime-one-of-the-candidates-listed-in-the-child-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/104473\/how-do-i-update-the-parent-cell-so-that-anytime-one-of-the-candidates-listed-in-the-child-cells","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/XE57T03QIBM0\/screen-shot-2023-04-25-at-7-26-04-pm.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2023-04-25 at 7.26.04 PM.png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-04-26T07:43:43+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"tagID":357,"urlcode":"overachievers","name":"overachievers"},{"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":103676,"type":"question","name":"What's the best way to get a total count and also categorize the results?","excerpt":"I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…","categoryID":322,"dateInserted":"2023-04-05T21:10:44+00:00","dateUpdated":null,"dateLastComment":"2023-04-21T20:31:29+00:00","insertUserID":160230,"insertUser":{"userID":160230,"name":"Ashley Klaers","title":"Work Documentation Specialist","url":"https:\/\/community.smartsheet.com\/profile\/Ashley%20Klaers","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!27FS_3T45Po!U61Rn4CHR0Q!Ibs3YVKZkL2","dateLastActive":"2023-05-01T21:45:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":148574,"lastUser":{"userID":148574,"name":"Ryan Sides","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Sides","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxZAMrkuia2jyTntTEVqOZJz5Exa9GVIeOjpXtCqnQ=s96-c","dateLastActive":"2023-06-02T00:02:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":65,"score":null,"hot":3362839933,"url":"https:\/\/community.smartsheet.com\/discussion\/103676\/whats-the-best-way-to-get-a-total-count-and-also-categorize-the-results","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/103676\/whats-the-best-way-to-get-a-total-count-and-also-categorize-the-results","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/BGE3QCQSU0ZM\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-04-21T17:52:22+00:00","dateAnswered":"2023-04-09T12:41:53+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":292,"urlcode":"Dashboards","name":"Dashboards"},{"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":64551,"type":"question","name":"Can't delete column, can't find conditional formatting rule that's preventing it","excerpt":"There was one conditional formatting rule that referenced the column in question. I deleted that rule, but still can't delete the column. Would be nice if SS would identify the any associated rules—am I missing something?","categoryID":321,"dateInserted":"2019-12-05T11:40:52+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2023-04-20T16:28:03+00:00","insertUserID":96241,"insertUser":{"userID":96241,"name":"Suzanne Raphael","url":"https:\/\/community.smartsheet.com\/profile\/Suzanne%20Raphael","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-19T15:45:57+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-06-05T09:50:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":665,"score":null,"hot":3257561335,"url":"https:\/\/community.smartsheet.com\/discussion\/64551\/cant-delete-column-cant-find-conditional-formatting-rule-thats-preventing-it","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/64551\/cant-delete-column-cant-find-conditional-formatting-rule-thats-preventing-it","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-21T13:44:09+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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}">