公式

TODAY(4), \"Yellow\") Any ideas on how to write an if formula to cover the date range? ","categoryID":322,"dateInserted":"2018-07-09T14:29:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-14T15:18:27+00:00","insertUserID":53841,"insertUser":{"userID":53841,"name":"KandiceKnoelk","url":"https:\/\/community.smartsheet.com\/profile\/KandiceKnoelk","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-xlX93GaHzw!8vNWd5Wp9jo!OHfo17hDyIE","dateLastActive":"2020-01-31T17:28:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":53841,"lastUser":{"userID":53841,"name":"KandiceKnoelk","url":"https:\/\/community.smartsheet.com\/profile\/KandiceKnoelk","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!-xlX93GaHzw!8vNWd5Wp9jo!OHfo17hDyIE","dateLastActive":"2020-01-31T17:28:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":58,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/28206\/help-automate-status-for-range-of-dates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/28206\/help-automate-status-for-range-of-dates","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":254,"urlcode":"Formulas","name":"Formulas"}],"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":36951,"type":"discussion","name":"Capturing multiple statuses, reminders for recurring tasks, form","excerpt":"Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following: I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks. The requirements: * Use a simple form to collect the data,…","categoryID":322,"dateInserted":"2018-12-05T22:34:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-14T04:14:49+00:00","insertUserID":71366,"insertUser":{"userID":71366,"name":"Robert Lopez O.","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20Lopez%20O.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-05T21:29:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-19T17:57:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":120,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/36951\/capturing-multiple-statuses-reminders-for-recurring-tasks-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/36951\/capturing-multiple-statuses-reminders-for-recurring-tasks-form","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":204,"urlcode":"Forms","name":"Forms"},{"tagID":223,"urlcode":"Publish","name":"Publish"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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":37131,"type":"discussion","name":"Calculating a percent","excerpt":"Hello, I am struggling to calculate the % complete based upon Target Savings \/ Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized. Any suggestions are appreciated. Thank so much, Katye","categoryID":322,"dateInserted":"2018-12-10T08:42:38+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-14T03:46:33+00:00","insertUserID":51391,"insertUser":{"userID":51391,"name":"Katye Reed","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Katye%20Reed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/47\/e4\/n47e417a625675c0c55a8e9a3eb9c663a.jpg","dateLastActive":"2021-10-27T20:01:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-06-19T17:57:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":1067,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/37131\/calculating-a-percent","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37131\/calculating-a-percent","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":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}]},{"discussionID":11006,"type":"question","name":"Seeking correct formula for \"If greater than, but less than\" statement.","excerpt":"If cell A is > 30, but < 61, then cell B is \"31 - 60\" ","categoryID":322,"dateInserted":"2017-06-30T14:20:17+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-13T19:29:58+00:00","insertUserID":3680,"insertUser":{"userID":3680,"name":"Darcie Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Darcie%20Wilson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-15T16:09:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":70521,"lastUser":{"userID":70521,"name":"Erik Johnson, PE","url":"https:\/\/community.smartsheet.com\/profile\/Erik%20Johnson%2C%20PE","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-03-13T14:33:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":125179,"score":null,"hot":10,"url":"https:\/\/community.smartsheet.com\/discussion\/11006\/seeking-correct-formula-for-if-greater-than-but-less-than-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/11006\/seeking-correct-formula-for-if-greater-than-but-less-than-statement","format":"Html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-07-28T15:27:58+00:00","dateAnswered":"2017-06-30T18:00:07+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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}],"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":37351,"type":"discussion","name":"COUNTIF CHILD AND UNRESOLVED","excerpt":"I have a sheet where we are tracking comments from various agencies. Each agency lists their comments as children under a parent row of the agency name. A separate checkbox column indicates whether the comment is resolved. I am trying to create a formula to calculate the number of unresolved comments per agency in each…","categoryID":322,"dateInserted":"2018-12-13T10:27:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-13T12:37:59+00:00","insertUserID":50676,"insertUser":{"userID":50676,"name":"K Munz","url":"https:\/\/community.smartsheet.com\/profile\/K%20Munz","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3OjYf4xchjY!hsDb4WgA_WQ!hQd-HGky5KQ","dateLastActive":"2022-06-29T21:35:57+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":1,"countViews":56,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/37351\/countif-child-and-unresolved","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37351\/countif-child-and-unresolved","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":254,"urlcode":"Formulas","name":"Formulas"}],"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}">