\"Complete\" AND [Due Date]<= TODAY, 1) I am not sure that I am combining the two statesments correctly. Can anyone…","categoryID":322,"dateInserted":"2019-08-23T09:48:19+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-09-06T10:09:21+00:00","insertUserID":71481,"insertUser":{"userID":71481,"name":"Andrea Mayer","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Mayer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-12\/70\/13\/n7013e5bc085aca330cd32c80e0bacae1.jpg","dateLastActive":"2023-04-11T21:55:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":71481,"lastUser":{"userID":71481,"name":"Andrea Mayer","url":"https:\/\/community.smartsheet.com\/profile\/Andrea%20Mayer","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-12\/70\/13\/n7013e5bc085aca330cd32c80e0bacae1.jpg","dateLastActive":"2023-04-11T21:55:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":72,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/56016\/formula-with-multiple-if-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56016\/formula-with-multiple-if-criteria","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":220,"urlcode":"hospitality","name":"Hospitality"},{"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}">
