公式

=IF(OR(TODAY() - [Last Contact Date]10 > 0, [Last Contact Date]10 = TODAY()), TODAY() - [Last Contact Date]10, \"Never\") The formula for check is a parent row is…","categoryID":318,"dateInserted":"2016-01-18T15:45:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-19T18:48:21+00:00","insertUserID":3399,"insertUser":{"userID":3399,"name":"Jeremy Myers","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Myers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-23T12:16:40+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":1,"countViews":2659,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/3957\/if-is-parent-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3957\/if-is-parent-row","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":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":281,"urlcode":"Support","name":"Support"}],"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":3962,"type":"discussion","name":"Changing the ball color on parent based on color of children","excerpt":"What I am trying to do is change the color of the RYG ball to red if any of the children have a red ball else leave it blank.","categoryID":318,"dateInserted":"2016-01-18T19:01:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-18T19:32:47+00:00","insertUserID":4898,"insertUser":{"userID":4898,"name":"Jeff Smith","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T16:16:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4898,"lastUser":{"userID":4898,"name":"Jeff Smith","url":"https:\/\/community.smartsheet.com\/profile\/Jeff%20Smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-19T16:16:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":37,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/3962\/changing-the-ball-color-on-parent-based-on-color-of-children","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3962\/changing-the-ball-color-on-parent-based-on-color-of-children","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":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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">