讨论
0, \"Green\", IF([Revised Due Date]1 - [Due Date]1 >…","categoryID":321,"dateInserted":"2018-05-21T05:22:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-24T11:23:13+00:00","insertUserID":34056,"insertUser":{"userID":34056,"name":"RobynTocco","url":"https:\/\/community.smartsheet.com\/profile\/RobynTocco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-24T09:07:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":34056,"lastUser":{"userID":34056,"name":"RobynTocco","url":"https:\/\/community.smartsheet.com\/profile\/RobynTocco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-24T09:07:30+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":216,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/25596\/if-statement-to-update-rag-status","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25596\/if-statement-to-update-rag-status","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"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":23546,"type":"discussion","name":"Notifications not working for 1 user","excerpt":"Hi there, I have an automatic notification set up to email the contact listed in a column once a day when the RAG status changes to red. This seems to be working so far for other contacts except for one individual. Any ideas what might be wrong? I made sure that the sheet was shared to the person, and that their contact…","categoryID":321,"dateInserted":"2018-04-13T09:12:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-04-13T10:16:02+00:00","insertUserID":34056,"insertUser":{"userID":34056,"name":"RobynTocco","url":"https:\/\/community.smartsheet.com\/profile\/RobynTocco","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-24T09:07:30+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":3,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/23546\/notifications-not-working-for-1-user","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/23546\/notifications-not-working-for-1-user","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[],"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}">
