勤奋✭

\/= 80 Green: 70 through 77 Yellow: 68 through 69 and 78 through 79 I just can't figure out how to link the ranges correctly.","categoryID":321,"dateInserted":"2022-06-16T18:01:46+00:00","dateUpdated":"2022-06-16T18:37:34+00:00","dateLastComment":"2022-06-16T18:49:09+00:00","insertUserID":143498,"insertUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":143498,"lastUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":74,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/92282\/red-yellow-green-status-with-range-values","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/92282\/red-yellow-green-status-with-range-values","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-16T18:49:09+00:00","acceptedAnswers":[]}},"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":89434,"type":"question","name":"COUNT that CONTAINS","excerpt":"How do I create a formula that COUNTS all the submissions that CONTAIN (using the Facility column): COUNT all that CONTAIN = DFW then provide a total count for just DFW COUNT all that CONTAIN = EP then provide a total count for just EP COUNT all that CONTAIN = LV then provide a total count for just LV COUNT all that…","categoryID":322,"dateInserted":"2022-03-26T04:09:55+00:00","dateUpdated":null,"dateLastComment":"2022-03-28T16:20:05+00:00","insertUserID":143498,"insertUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":143498,"lastUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":86,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/89434\/count-that-contains","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89434\/count-that-contains","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/Y5EPPLJDOAV1\/capture-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-28T16:20:19+00:00","dateAnswered":"2022-03-28T08:59:50+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":89433,"type":"question","name":"Status Change RYG for Pass or Fail","excerpt":"I have a sheet with 20 different [Pass Fail 1], [Pass Fail 2], [Pass Fail 3], etc.. columns that if any Fail I would like the status RYG to turn Red. Then if all Pass to be Green. I have never created a formula that has a range of columns I want it to validate as a whole. Any suggestions?","categoryID":322,"dateInserted":"2022-03-26T02:06:38+00:00","dateUpdated":null,"dateLastComment":"2022-03-26T03:28:48+00:00","insertUserID":143498,"insertUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":143498,"lastUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":120,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/89433\/status-change-ryg-for-pass-or-fail","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/89433\/status-change-ryg-for-pass-or-fail","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-03-26T03:28:50+00:00","dateAnswered":"2022-03-26T02:32:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":86609,"type":"question","name":"Duration Counter\/Timer","excerpt":"Is there a way in SS, that when using an auto-generated created date\/time, that a duration column will count how long since it was submitted. Then have a date & a time column for completion that will stop the timer?","categoryID":322,"dateInserted":"2022-01-17T15:37:56+00:00","dateUpdated":null,"dateLastComment":"2022-01-25T14:08:19+00:00","insertUserID":143498,"insertUser":{"userID":143498,"name":"HardWork","url":"https:\/\/community.smartsheet.com\/profile\/HardWork","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bOHUG1yERn4!pZlUqXdjszo!4qV2ni52zF-","dateLastActive":"2023-01-03T18:07:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T21:50:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":388,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/86609\/duration-counter-timer","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86609\/duration-counter-timer","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-06-16T18:02:56+00:00","dateAnswered":"2022-01-25T14:08:19+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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}">