公式

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-22T11:27:08+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-22T11:27:08+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":125300,"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-21T20:00:08+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}]},{"discussionID":37286,"type":"discussion","name":"Formula for a group selection","excerpt":"I want to count the number of items when their description contains a certain word. Count if Description contains the word \"grey\". There would be multiple descriptions with the word GREY in the column. Ex. Dark Grey, Grey Mist, Green Grey, Blue Grey. I want a total for all items that are GREY. Is this possible? Other…","categoryID":322,"dateInserted":"2018-12-12T15:10:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-13T11:39:27+00:00","insertUserID":57331,"insertUser":{"userID":57331,"name":"Dee Barnard","url":"https:\/\/community.smartsheet.com\/profile\/Dee%20Barnard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-10\/2a\/96\/n2a960f1ec8eba8ba151a42ce07fd7a53.jpg","dateLastActive":"2021-04-01T13:42:25+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-21T20:00:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":90,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/37286\/formula-for-a-group-selection","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37286\/formula-for-a-group-selection","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":37276,"type":"discussion","name":"Find and Replace to edit references","excerpt":"Hi! I am trying to edit the three cross-sheet references in all the columns from the master sheet of 2018 to master sheet of 2019. Since I need to repeat it for almost 1200 cells. Is there a way to bulk edit like Find and Replace or something else? Even for selected cells will make it so much easier! the original is :…","categoryID":322,"dateInserted":"2018-12-12T14:17:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-13T11:37:58+00:00","insertUserID":70371,"insertUser":{"userID":70371,"name":"Swathi.Chaturvedi","url":"https:\/\/community.smartsheet.com\/profile\/Swathi.Chaturvedi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-11T15:09:58+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-21T20:00:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":594,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/37276\/find-and-replace-to-edit-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37276\/find-and-replace-to-edit-references","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/7c\/d0\/7cd00d73bb83b54c67c97cc549168e29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-12-12 at 12.13.16 PM.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":279,"urlcode":"Marketing","name":"Marketing"}],"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":37201,"type":"discussion","name":"Reference the value of an active cell?","excerpt":"Is there a way to reference the value of an 'active cell value' in a formula or have a moving reference? The current example code and screenshot specifically call out the desired outcome by referencing each cell in a range. Example: Project1 will start in 2018, which is reflected on sheet 2. formula in column 2 row 2 on…","categoryID":322,"dateInserted":"2018-12-11T14:52:42+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-12T14:14:27+00:00","insertUserID":71906,"insertUser":{"userID":71906,"name":"Sean N","url":"https:\/\/community.smartsheet.com\/profile\/Sean%20N","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-06-05T14:33:54+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-21T20:00:08+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":291,"score":1,"hot":3120421934,"url":"https:\/\/community.smartsheet.com\/discussion\/37201\/reference-the-value-of-an-active-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37201\/reference-the-value-of-an-active-cell","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/04\/12\/04122c122788048fb9b733fd2873ff64.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet1.JPG"},"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":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":37126,"type":"discussion","name":"BUG?! - Inconsistent Date Format (US\/UK)","excerpt":"I have a regular gantt sheet with start date \/ end date, which shows up in UK format on the sheet as per my personal settings. However, when I link to that cell from a metadata sheet that I am using for dashboards the date shows up in US format! I have another date format column which is for baseline start and baseline end…","categoryID":322,"dateInserted":"2018-12-10T07:12:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-12T13:44:16+00:00","insertUserID":48106,"insertUser":{"userID":48106,"name":"Mr.Hyde","url":"https:\/\/community.smartsheet.com\/profile\/Mr.Hyde","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-08\/0b\/dc\/n0bdc7c92e83bda9a598c58c08958541c.jpg","dateLastActive":"2019-11-06T10:03:12+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45236,"lastUser":{"userID":45236,"name":"Alejandra","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Alejandra","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-04\/8a\/fe\/n8afeceb592ad5845f46c7d931defba07.JPG","dateLastActive":"2020-05-15T18:56:51+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":75,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/37126\/bug-inconsistent-date-format-us-uk","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37126\/bug-inconsistent-date-format-us-uk","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"},{"tagID":263,"urlcode":"Government","name":"Government"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":37206,"type":"discussion","name":"NETDAYS failure","excerpt":"I cannot figure out why this formula doesn't work for me. I've tried a date instead of TODAY(), same results. Any help appreciated. Both columns are formatted for dates.","categoryID":322,"dateInserted":"2018-12-11T16:06:33+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-12-12T13:17:24+00:00","insertUserID":71951,"insertUser":{"userID":71951,"name":"KyleRL","url":"https:\/\/community.smartsheet.com\/profile\/KyleRL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-11T16:05:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":71951,"lastUser":{"userID":71951,"name":"KyleRL","url":"https:\/\/community.smartsheet.com\/profile\/KyleRL","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-12-11T16:05:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":557,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/37206\/netdays-failure","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/37206\/netdays-failure","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-12\/71\/05\/7105c499320ef14520c5793fcc364f70.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-12-11 at 1.04.56 PM.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":391,"urlcode":"product-development","name":"Product Development"}],"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}">