\n ![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/DI7AJBFRUMWE\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 19:05:25","updateUser":{"userID":149803,"name":"Ryan Holguin","url":"https:\/\/community.smartsheet.com\/profile\/Ryan%20Holguin","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ejDcJ2x9GOY!pRNd6WBKr7Q!uGy-EViqsyg","dateLastActive":"2022-09-23T19:52:03+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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":95856,"type":"question","name":"COUNTIFS with OR","excerpt":"Hello, I have spent hours trying to figure out what I am doing wrong, but I cannot seem to figure out what would get this formula to work. I am trying to count if my Simulation column says Phillips, the complete checkbox is checked and Type is Pilot OR Simulation. The formula works fine up until I add in the Type being…","categoryID":322,"dateInserted":"2022-09-23T16:42:25+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T17:09:29+00:00","insertUserID":152718,"insertUser":{"userID":152718,"name":"erin.smith","url":"https:\/\/community.smartsheet.com\/profile\/erin.smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T20:21:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":132999,"lastUser":{"userID":132999,"name":"Frank.Smith","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Frank.Smith","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u2crl8Itmjo!jZnr444A07I!hA7gZMqaJJS","dateLastActive":"2022-09-23T17:48:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":38,"score":null,"hot":3327905514,"url":"https:\/\/community.smartsheet.com\/discussion\/95856\/countifs-with-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95856\/countifs-with-or","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":95856,"commentID":344589,"name":"Re: COUNTIFS with OR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344589#Comment_344589","dateInserted":"2022-09-23T17:09:29+00:00","insertUserID":132999,"insertUser":{"userID":132999,"name":"Frank.Smith","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Frank.Smith","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!u2crl8Itmjo!jZnr444A07I!hA7gZMqaJJS","dateLastActive":"2022-09-23T17:48:46+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-09-23T17:45:37+00:00","dateAnswered":"2022-09-23T17:09:29+00:00","acceptedAnswers":[{"commentID":344589,"body":"
Greetings Erin,<\/p>
Here is the formula I think should resolve your problem:<\/p>
=COUNTIFS(Simulation:Simulation, \"Phillips\", Complete:Complete, \"1\", Type:Type, OR(@cell = \"Pilot\", @cell = \"Simulation\"))<\/p>
For the OR statement, you can reference the @cell for your comparisons.<\/p>
Please let me know how this works.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 17:45:37","updateUser":{"userID":152718,"name":"erin.smith","url":"https:\/\/community.smartsheet.com\/profile\/erin.smith","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-23T20:21:23+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":95854,"type":"question","name":"How to use symbols with formula","excerpt":"=IF([\"Will Call\" Trips]@row < [\"Will Call\" Goal]@row, \"Yes\", \"No\") What do I use if I want the symbol to be Hold if the answer is zero?","categoryID":322,"dateInserted":"2022-09-23T16:27:32+00:00","dateUpdated":null,"dateLastComment":"2022-09-23T16:34:10+00:00","insertUserID":7176,"insertUser":{"userID":7176,"name":"Samuel Dowdy Jr.","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Dowdy%20Jr.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xCPC8T7_6Hw!zIfBc_qPyz4!RrIUl9SqFWX","dateLastActive":"2022-09-23T18:18:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":145151,"lastUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmniEdReOVTwaHHrhgrOiwux3krYT43KIqrvf5FW=s96-c","dateLastActive":"2022-09-23T21:56:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":21,"score":null,"hot":3327901902,"url":"https:\/\/community.smartsheet.com\/discussion\/95854\/how-to-use-symbols-with-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95854\/how-to-use-symbols-with-formula","format":"Rich","lastPost":{"discussionID":95854,"commentID":344574,"name":"Re: How to use symbols with formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/344574#Comment_344574","dateInserted":"2022-09-23T16:34:10+00:00","insertUserID":145151,"insertUser":{"userID":145151,"name":"Mike TV","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20TV","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AItbvmniEdReOVTwaHHrhgrOiwux3krYT43KIqrvf5FW=s96-c","dateLastActive":"2022-09-23T21:56:03+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-09-23T18:18:59+00:00","dateAnswered":"2022-09-23T16:34:10+00:00","acceptedAnswers":[{"commentID":344574,"body":"
@Samuel Dowdy Jr.<\/a> <\/p>=IF([\"Will Call\" Trips]@row=0, \"Hold\", IF([\"Will Call\" Trips]@row < [\"Will Call\" Goal]@row, \"Yes\", \"No\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-09-23 18:18:59","updateUser":{"userID":7176,"name":"Samuel Dowdy Jr.","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Dowdy%20Jr.","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xCPC8T7_6Hw!zIfBc_qPyz4!RrIUl9SqFWX","dateLastActive":"2022-09-23T18:18:40+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":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
保罗新来的 ✭✭✭✭✭✭
丹西 ✭
![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/CIQNPOWD5RQ4\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/9ZYWEF1DBJGN\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
