Formulas

138 and my \"% Complete\" column is < 50% Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)),…","categoryID":322,"dateInserted":"2018-06-15T10:15:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-15T12:09:54+00:00","insertUserID":51526,"insertUser":{"userID":51526,"name":"bday2329","title":"","url":"https:\/\/community.smartsheet.com\/profile\/bday2329","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-03T21:17:37+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\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":91,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/27036\/if-and","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27036\/if-and","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":26961,"type":"discussion","name":"Countif formula suddenly stopped working","excerpt":"Hello, I have a formula that has been working perfectly for the past 8 months. It's a very simple count if formula. Below is the formula that I copied directly from smartsheets. Anyone have an idea why this all of a sudden returned an \"invalid opeartion\" error when it has been working before? =COUNTIF(Status:Status, \"Red\")…","categoryID":322,"dateInserted":"2018-06-14T11:02:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-14T11:57:16+00:00","insertUserID":14976,"insertUser":{"userID":14976,"name":"Jawanza Hadley","url":"https:\/\/community.smartsheet.com\/profile\/Jawanza%20Hadley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-11\/2d\/08\/n2d083c99ee208833d8ee158468f6baf8.jpg","dateLastActive":"2019-08-28T11:20:15+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":96,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/26961\/countif-formula-suddenly-stopped-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26961\/countif-formula-suddenly-stopped-working","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":26321,"type":"discussion","name":"Formula help - if cell range contain any text, check the checkbox, otherwise uncheck","excerpt":"Hi All, I'm new to Smartsheet and was hoping someone might be able to help. I'm trying to build a formula where if a range of cells with that row contain any text, a checkbox is checked. But if anyone of the cells in that range has not been filled out, the box is not checked. ","categoryID":322,"dateInserted":"2018-06-01T12:27:26+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-14T08:47:43+00:00","insertUserID":48396,"insertUser":{"userID":48396,"name":"Jamie Null","url":"https:\/\/community.smartsheet.com\/profile\/Jamie%20Null","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-11-14T12:36:39+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":1315,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/26321\/formula-help-if-cell-range-contain-any-text-check-the-checkbox-otherwise-uncheck","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26321\/formula-help-if-cell-range-contain-any-text-check-the-checkbox-otherwise-uncheck","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":274,"urlcode":"legal","name":"Legal"},{"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}]},{"discussionID":5755,"type":"discussion","name":"Common Picklist","excerpt":"Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?","categoryID":318,"dateInserted":"2016-08-09T11:58:47+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T23:32:05+00:00","insertUserID":6254,"insertUser":{"userID":6254,"name":"kbarhoover","url":"https:\/\/community.smartsheet.com\/profile\/kbarhoover","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-28T15:35:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":21126,"lastUser":{"userID":21126,"name":"JeremiahHorstick","url":"https:\/\/community.smartsheet.com\/profile\/JeremiahHorstick","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-07\/5b\/45\/n5b45eb0c1a48afae956282248c8ad587.jpg","dateLastActive":"2023-08-11T02:52:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":552,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/5755\/common-picklist","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5755\/common-picklist","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":507,"urlcode":"enhancement-request","name":"Enhancement Request"}],"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":26926,"type":"discussion","name":"date formula referencing specific date cell","excerpt":"Hi, I am working in a date column that has the Effective Date: 05\/13\/2019. I want the Project Kick-off Date to reference the Effective Date - What formula do I enter so that: (i) the Year is always the year listed in the effective date cell, (ii) month is always January, and (iii) Day is always 01? I have tried this…","categoryID":322,"dateInserted":"2018-06-13T18:58:10+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T20:14:36+00:00","insertUserID":33971,"insertUser":{"userID":33971,"name":"adithi33971","url":"https:\/\/community.smartsheet.com\/profile\/adithi33971","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/09\/6c\/n096c9a913d76768f2c2a0b005df8e121.PNG","dateLastActive":"2019-07-24T18:43:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":33971,"lastUser":{"userID":33971,"name":"adithi33971","url":"https:\/\/community.smartsheet.com\/profile\/adithi33971","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-01\/09\/6c\/n096c9a913d76768f2c2a0b005df8e121.PNG","dateLastActive":"2019-07-24T18:43:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":754,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/26926\/date-formula-referencing-specific-date-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26926\/date-formula-referencing-specific-date-cell","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":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":26796,"type":"discussion","name":"Help getting Index\/Match to find search value (number) in a cell with multiple values (numbers)","excerpt":"I have a sheet with the following formula in a column titled \"Status\": =IF(ISBLANK([PO#]1), \"Processing\", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = \"Loaded\", \"OTR\", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = \"available load\", \"Logistics Dept\", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range},…","categoryID":322,"dateInserted":"2018-06-12T13:38:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T16:10:13+00:00","insertUserID":51101,"insertUser":{"userID":51101,"name":"Jay1","url":"https:\/\/community.smartsheet.com\/profile\/Jay1","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgAn1rPUMejfMbS3vzg-FxOr6ybFwlv98nkfaxv8Q=s96-c","dateLastActive":"2021-04-19T14:35:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":51101,"lastUser":{"userID":51101,"name":"Jay1","url":"https:\/\/community.smartsheet.com\/profile\/Jay1","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AOh14GgAn1rPUMejfMbS3vzg-FxOr6ybFwlv98nkfaxv8Q=s96-c","dateLastActive":"2021-04-19T14:35:36+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":14,"countViews":694,"score":null,"hot":14,"url":"https:\/\/community.smartsheet.com\/discussion\/26796\/help-getting-index-match-to-find-search-value-number-in-a-cell-with-multiple-values-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26796\/help-getting-index-match-to-find-search-value-number-in-a-cell-with-multiple-values-numbers","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-06\/6e\/a0\/6ea0269f1384193cb0474d2ce470df72.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"for f.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":214,"urlcode":"search","name":"Search"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":26871,"type":"discussion","name":"Countifs + AND\/OR functions","excerpt":"Hi, I'm trying to create a table to display via a dashboard that shows project status in three categories: Complete, in progress, other. Other includes 3 different values that i need to group into that \"other\" category. How do you smart folks recommend i do this. I've tried a bunch of things but i get invalid #INVALID DATA…","categoryID":322,"dateInserted":"2018-06-13T12:08:03+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T15:56:03+00:00","insertUserID":30856,"insertUser":{"userID":30856,"name":"Jose Iguiniz","url":"https:\/\/community.smartsheet.com\/profile\/Jose%20Iguiniz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-30T12:45:22+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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":51,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/26871\/countifs-and-or-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26871\/countifs-and-or-functions","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":26816,"type":"discussion","name":"Cross sheet formula\/reference","excerpt":"Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an accumulation of weekly data that the 6 sheets feed into. Each sheet has a different employee inputting different data. So, If…","categoryID":322,"dateInserted":"2018-06-12T14:30:39+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T14:36:23+00:00","insertUserID":35371,"insertUser":{"userID":35371,"name":"tye.gardner35371","url":"https:\/\/community.smartsheet.com\/profile\/tye.gardner35371","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-02-27T20:42:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":193,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/26816\/cross-sheet-formula-reference","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26816\/cross-sheet-formula-reference","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":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":26741,"type":"discussion","name":"Color Auto-Changes","excerpt":"I have my sheet coded so that the status updates as the due date approaches, passes, etc. The only problem is that in a row where the due date is blank it considers it 'Late' and makes it red. I would like for it to just leave the status blank in that row. This is the formula I had used: =IF([Date Due]3 < TODAY(), \"Red\",…","categoryID":322,"dateInserted":"2018-06-11T13:25:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T11:36:26+00:00","insertUserID":50861,"insertUser":{"userID":50861,"name":"megtimmi","url":"https:\/\/community.smartsheet.com\/profile\/megtimmi","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-02T11:24:07+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\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":62,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/26741\/color-auto-changes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26741\/color-auto-changes","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-06\/26\/36\/2636bd0f73148f0c7049a07ef7ef46f0.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-06-11 at 12.09.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"}],"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":26831,"type":"discussion","name":"Beware behind the scenes Date Format","excerpt":"Background: A colleague of mine ran into a problem with Dashboards being fed from a Summary sheet which was pulling data from Main sheets via X-Sheet References. The Dashboards were showing incorrect values until the Summary sheet was refreshed (opened) Investigation reveals (I believe) that the issue is due to how…","categoryID":322,"dateInserted":"2018-06-13T07:06:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-06-13T07:13:38+00:00","insertUserID":4374,"insertUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":237,"lastUser":{"userID":237,"name":"Richard Rymill SBP","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Rymill%20SBP","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/56\/cc\/n56cc5e719e36b8b84e97c4c58049f914.jpg","dateLastActive":"2023-08-07T12:19:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":63,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/26831\/beware-behind-the-scenes-date-format","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26831\/beware-behind-the-scenes-date-format","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}">