=DATE(2018,1,1),@cell<=DATE(2018,3,31))) Thanks ahead of time for any thoughts!","categoryID":322,"dateInserted":"2018-08-24T19:22:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-27T11:56:11+00:00","insertUserID":57851,"insertUser":{"userID":57851,"name":"KO_in_Colo","url":"https:\/\/community.smartsheet.com\/profile\/KO_in_Colo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-11T12:07:18+00:00","banned":0,"punished":0,"private":false,"label":""},"updateUserID":null,"lastUserID":57851,"lastUser":{"userID":57851,"name":"KO_in_Colo","url":"https:\/\/community.smartsheet.com\/profile\/KO_in_Colo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-11T12:07:18+00:00","banned":0,"punished":0,"private":false,"label":""},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/31271\/how-to-count-within-a-date-range-in-first-column-and-with-a-specific-criteria-in-a-second-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/31271\/how-to-count-within-a-date-range-in-first-column-and-with-a-specific-criteria-in-a-second-column","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":31146,"type":"discussion","name":"Auto Status Change\/Update","excerpt":"Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08\/24\/2018 and it is 08\/25\/2018 and the status box of completion is not checked yet, is there a way to create…","categoryID":322,"dateInserted":"2018-08-23T13:20:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-08-27T09:37:53+00:00","insertUserID":59051,"insertUser":{"userID":59051,"name":"rochen","url":"https:\/\/community.smartsheet.com\/profile\/rochen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-29T09:17:32+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-10-10T14:04:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":891,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/31146\/auto-status-change-update","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/31146\/auto-status-change-update","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":213,"urlcode":"Conditional Formatting","name":"Conditional Formatting"},{"tagID":215,"urlcode":"Templates","name":"Templates"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":228,"urlcode":"Project Management","name":"Project Management"},{"tagID":244,"urlcode":"Product Development","name":"Product Development"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":269,"urlcode":"Gantt View","name":"Gantt View"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"}],"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}">
This will convert everything into text strings so that you have the same data type throughout. You would then use these helper columns in your formula.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-10-07 21:47:15","updateUser":{"userID":140332,"name":"twarner","url":"https:\/\/community.smartsheet.com\/profile\/twarner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-07T21:47:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":96340,"type":"question","name":"IF formula with Multiple conditions- help required","excerpt":"Hi, I am trying to work out the forumla that is based on a lead time field (manually entered) vs turnaround field (automatically calculated on dates) , the formula I want has multiple conditions which I am struggling to put into one IF formula, would appreciate anyones help - thanks\/ I want to have a formula that says: IF…","categoryID":322,"dateInserted":"2022-10-07T10:39:38+00:00","dateUpdated":null,"dateLastComment":"2022-10-07T11:27:54+00:00","insertUserID":137102,"insertUser":{"userID":137102,"name":"Laura Byrne","url":"https:\/\/community.smartsheet.com\/profile\/Laura%20Byrne","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!upsqVxYhnDs!7yMr-74eQAs!Q44B0N7isTy","dateLastActive":"2022-10-07T11:22:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-10T15:54:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":32,"score":null,"hot":3330283052,"url":"https:\/\/community.smartsheet.com\/discussion\/96340\/if-formula-with-multiple-conditions-help-required","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/96340\/if-formula-with-multiple-conditions-help-required","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":96340,"commentID":346433,"name":"Re: IF formula with Multiple conditions- help required","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/346433#Comment_346433","dateInserted":"2022-10-07T11:27:54+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/f4\/d4\/nf4d40b307033e1c1fd4cfe2ab2c10220.jpg","dateLastActive":"2022-10-10T15:54:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-10-07T11:25:24+00:00","dateAnswered":"2022-10-07T11:18:41+00:00","acceptedAnswers":[{"commentID":346429,"body":"
