Discussions
\"Empty\", Progress1 < \"Full\"), \"In Progress\", IF(Progress1 = \"Full\", \"COMPLETED!\") This is the formula. I want the status to show either 'Not Started' , 'In Progress', or COMPLETED! based on…","categoryID":322,"dateInserted":"2019-08-23T17:31:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2021-05-21T09:52:02+00:00","insertUserID":101406,"insertUser":{"userID":101406,"name":"V1LL4M4R","url":"https:\/\/community.smartsheet.com\/profile\/V1LL4M4R","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-10-02T12:03:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":136200,"lastUser":{"userID":136200,"name":"Yoko Yabe","url":"https:\/\/community.smartsheet.com\/profile\/Yoko%20Yabe","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bDtWGwdtSTo!7UFV-6dLSPo!8aAU_wbvNxL","dateLastActive":"2022-01-13T11:24:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":680,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/56116\/change-status-if-progress-bar-changes-help-w-syntax","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/56116\/change-status-if-progress-bar-changes-help-w-syntax","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/79\/b7\/79b76affa3ee23a466875c73da5f585d.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":false,"noCheckboxes":true}">
