= 1% and \"%Complete\" <= 99% and \"At Risk\" = 0 then \"Status\" = In Progress 2) If \"%Complete\" >= 1% and \"%Complete\" <= 99% and…","categoryID":317,"dateInserted":"2015-11-11T19:49:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-11-12T18:54:42+00:00","insertUserID":3345,"insertUser":{"userID":3345,"name":"Ray Rios","url":"https:\/\/community.smartsheet.com\/profile\/Ray%20Rios","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-05-11T14:27:44+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":2,"countViews":668,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/3541\/nesting-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3541\/nesting-formulas","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/99\/e1\/99e164e3b3691533f0aacd12cbe5b1d1.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":234,"urlcode":"Health-care","name":"Healthcare"},{"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}">
