Discussions
(DATE(2023, 5, 26)), {Date Activated}, <(DATE(2023, 6, 2)), {Status}, OR(@cell = \"ACTIVE\", @cell = \"DISCHARGED\")) However, i need to add in an OR function to the first 2 phrases. it should count if {discharged date} is greater thatn 5.26.23 or Blank, AND {Date…","categoryID":322,"dateInserted":"2023-06-28T15:33:45+00:00","dateUpdated":null,"dateLastComment":"2023-06-29T12:30:18+00:00","insertUserID":162885,"insertUser":{"userID":162885,"name":"Ymandel","title":"President","url":"https:\/\/community.smartsheet.com\/profile\/Ymandel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T02:03:04+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":3,"countViews":52,"score":null,"hot":3376010043,"url":"https:\/\/community.smartsheet.com\/discussion\/107023\/or-function-help-needed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107023\/or-function-help-needed","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2023-06-29T12:30:18+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":107015,"type":"question","name":"Coiuntifs Formula Help Needed","excerpt":"Hi! Can anyone please assist with the correct Formula? i'm trying to count how many rows are on a sheet(Reference Sheet) the criterea for the rows are as follows: =countifs STATUS Column is \"Discharged\" or \"ACTIVE\" , Discharged\/Nonadmit Column is Greater than 05\/19\/2023 and Date activated column is less than 05\/27\/2023 I…","categoryID":322,"dateInserted":"2023-06-28T13:59:55+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T14:35:02+00:00","insertUserID":162885,"insertUser":{"userID":162885,"name":"Ymandel","title":"President","url":"https:\/\/community.smartsheet.com\/profile\/Ymandel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T02:03:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162885,"lastUser":{"userID":162885,"name":"Ymandel","title":"President","url":"https:\/\/community.smartsheet.com\/profile\/Ymandel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-03T02:03:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":53,"score":null,"hot":3375925497,"url":"https:\/\/community.smartsheet.com\/discussion\/107015\/coiuntifs-formula-help-needed","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107015\/coiuntifs-formula-help-needed","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T14:22:57+00:00","dateAnswered":"2023-06-28T14:10:08+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}">
