讨论
\/= 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":"2022-07-08T15:53:24+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":"2022-07-08T15:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":33,"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":"2022-07-08T15:53:24+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":"2022-07-08T15:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":35,"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":"2022-07-08T15:53:24+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":"2022-07-08T15:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":46,"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":"2022-07-08T15:53:24+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":"2022-12-05T19:12:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":184,"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}]},{"discussionID":87091,"type":"question","name":"=NETDAYS","excerpt":"I keep getting an error message: I am trying to set the duration between when approval to close and approval to open but in hours and minutes. When I referenced the Sheet to {Approver Time Stamp Open} I only chose the one column. =NETDAYS([Approver Time Stamp Close]@row, {Approver Time Stamp Open}@row)","categoryID":322,"dateInserted":"2022-01-24T02:30:34+00:00","dateUpdated":null,"dateLastComment":"2022-01-24T16:23:00+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":"2022-07-08T15:53:24+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":"2022-07-08T15:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":89,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/87091\/netdays","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/87091\/netdays","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-01-24T07:03:32+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":86642,"type":"question","name":"Pull Contact Info From Another Sheet Automatically","excerpt":"This way as staff changes I only need to update the market details sheet to update all my other sheets.","categoryID":322,"dateInserted":"2022-01-18T15:56:50+00:00","dateUpdated":null,"dateLastComment":"2022-01-24T13:03:02+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":"2022-07-08T15:53:24+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":"2022-12-05T19:12:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":148,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/86642\/pull-contact-info-from-another-sheet-automatically","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86642\/pull-contact-info-from-another-sheet-automatically","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/P0UC6NI5PLLN\/contacts-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Contacts.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-25T16:45:09+00:00","dateAnswered":"2022-01-24T13:03:02+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":86573,"type":"question","name":"Which formula to use?","excerpt":"","categoryID":322,"dateInserted":"2022-01-14T22:26:13+00:00","dateUpdated":null,"dateLastComment":"2022-01-18T17:27:30+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":"2022-07-08T15:53:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/518\/n0UL39EAWX965.jpg","dateLastActive":"2022-12-01T17:59:13+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":46,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/86573\/which-formula-to-use","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86573\/which-formula-to-use","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/B05LH3KOMKKW\/smartsheet-question-1-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"smartsheet question 1.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-01-14T22:32:30+00:00","dateAnswered":"2022-01-14T22:30:41+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}">
