Formulas and Functions

Sorry to re-post, but the forum won't let me edit the previous post<\/p>

The second formula is syntactically incorrect. The criterion parameters can only specify a single value. Just repeat the addition as you already started to do:<\/p>

=COUNTIFS({LV_ BLD CONST QUERY REGISTER _open status}, \"open\", {LV_ BLD CONST QUERY REGISTER _resp}, \"T_Mem1\")+ COUNTIFS({LV_ BLD CONST QUERY REGISTER _open status}, \"open\", {LV_ BLD CONST QUERY REGISTER _resp}, \"T_Mem2\") + COUNTIFS({LV_ BLD CONST QUERY REGISTER _open status}, \"open\", {LV_ BLD CONST QUERY REGISTER _co-resp}, \"T_Mem1\") + COUNTIFS({LV_ BLD CONST QUERY REGISTER _open status}, \"open\", {LV_ BLD CONST QUERY REGISTER _co-resp}, \"T_Mem2\")<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":110823,"type":"question","name":"I am trying to compare 2 date columns with an odd result","excerpt":"I am trying to count the number of submissions on a daily basis with =COUNTIF({Loans Range 1}, =[Begin Date]@row). Most of the formulas return the correct number of submissions. What it looks like it is doing is applying the submissions entered after a certain time (5 PM?) to the next day. Dependencies are disabled…","snippet":"I am trying to count the number of submissions on a daily basis with =COUNTIF({Loans Range 1}, =[Begin Date]@row). Most of the formulas return the correct number of submissions.…","categoryID":322,"dateInserted":"2023-09-26T21:08:56+00:00","dateUpdated":null,"dateLastComment":"2023-09-26T22:12:00+00:00","insertUserID":147499,"insertUser":{"userID":147499,"name":"Ryan Abraham","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Abraham","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T22:04:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":147499,"lastUser":{"userID":147499,"name":"Ryan Abraham","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Abraham","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T22:04:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":13,"score":null,"hot":3391530056,"url":"https:\/\/community.smartsheet.com\/discussion\/110823\/i-am-trying-to-compare-2-date-columns-with-an-odd-result","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110823\/i-am-trying-to-compare-2-date-columns-with-an-odd-result","format":"Rich","lastPost":{"discussionID":110823,"commentID":397108,"name":"Re: I am trying to compare 2 date columns with an odd result","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397108#Comment_397108","dateInserted":"2023-09-26T22:12:00+00:00","insertUserID":147499,"insertUser":{"userID":147499,"name":"Ryan Abraham","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Abraham","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T22:04:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-27T11:33:58+00:00","dateAnswered":"2023-09-26T21:51:50+00:00","acceptedAnswers":[{"commentID":397101,"body":"

@Ryan Abraham<\/a> Try creating a helper column, called DateOnly and apply that to the Created Date column and refer to that. It will remove the time and just give you a date to reference.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]},{"discussionID":110798,"type":"question","name":"Revise Formula to include a but","excerpt":"My current formula in one column that is working out is the below: =IF(OR(CONTAINS(\"Term\", [Column1]@row), [Column2]@row = 1), \"Green\", \"Yellow\") For the next column I need a revised formula to say \"if the term is in column 1 and column 2 is check BUT Column 3 is checked then it will give me a red ball\" What do I need to…","snippet":"My current formula in one column that is working out is the below: =IF(OR(CONTAINS(\"Term\", [Column1]@row), [Column2]@row = 1), \"Green\", \"Yellow\") For the next column I need a…","categoryID":322,"dateInserted":"2023-09-26T17:10:03+00:00","dateUpdated":null,"dateLastComment":"2023-09-26T21:40:25+00:00","insertUserID":160871,"insertUser":{"userID":160871,"name":"Nana250","url":"https:\/\/community.smartsheet.com\/profile\/Nana250","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T21:40:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":160871,"lastUser":{"userID":160871,"name":"Nana250","url":"https:\/\/community.smartsheet.com\/profile\/Nana250","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T21:40:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":52,"score":null,"hot":3391518628,"url":"https:\/\/community.smartsheet.com\/discussion\/110798\/revise-formula-to-include-a-but","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110798\/revise-formula-to-include-a-but","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110798,"commentID":397096,"name":"Re: Revise Formula to include a but","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397096#Comment_397096","dateInserted":"2023-09-26T21:40:25+00:00","insertUserID":160871,"insertUser":{"userID":160871,"name":"Nana250","url":"https:\/\/community.smartsheet.com\/profile\/Nana250","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T21:40:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-26T21:40:07+00:00","dateAnswered":"2023-09-26T20:43:54+00:00","acceptedAnswers":[{"commentID":397090,"body":"

Got it - then try this: =IF([Column 3]@row = 1, \"Red\", IF(OR(CONTAINS(\"Term\", [Column 1]@row), [Column 2]@row = 1), \"Green\", \"Yellow\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=322&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">