服务

30,\"Red\",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),\"Yellow\", IF(OR(TODAY-[INVOICE DUE…","categoryID":318,"dateInserted":"2016-08-19T06:58:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-19T16:38:59+00:00","insertUserID":7893,"insertUser":{"userID":7893,"name":"Ladislav","url":"https:\/\/community.smartsheet.com\/profile\/Ladislav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-19T16:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7893,"lastUser":{"userID":7893,"name":"Ladislav","url":"https:\/\/community.smartsheet.com\/profile\/Ladislav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-19T16:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":86,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5855\/nested-if-formula-using-additional-and-or-logical-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5855\/nested-if-formula-using-additional-and-or-logical-functions","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":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"}],"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}">