Formulas and Functions

0, \"Red\", \"Yellow\")) Please help me figure out where the error is. I need to…","categoryID":322,"dateInserted":"2021-01-23T07:00:21+00:00","dateUpdated":null,"dateLastComment":"2021-01-24T04:46:19+00:00","insertUserID":131049,"insertUser":{"userID":131049,"name":"Carol Rykovanova","url":"https:\/\/community.smartsheet.com\/profile\/Carol%20Rykovanova","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-16T07:20:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":131049,"lastUser":{"userID":131049,"name":"Carol Rykovanova","url":"https:\/\/community.smartsheet.com\/profile\/Carol%20Rykovanova","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-02-16T07:20:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":257,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/75202\/how-to-sum-up-column-rgy-statuses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75202\/how-to-sum-up-column-rgy-statuses","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2021-01-24T04:31:55+00:00","dateAnswered":"2021-01-24T04:17:59+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":75195,"type":"question","name":"What's wrong with my formula?","excerpt":"=COUNTIFS(Position2:Position196, CONTAINS(\"Medical Assistant\", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS(\"No\", @cell), CONTAINS(\"Contingent\", @cell)))","categoryID":322,"dateInserted":"2021-01-22T23:16:08+00:00","dateUpdated":null,"dateLastComment":"2021-01-23T00:52:35+00:00","insertUserID":130636,"insertUser":{"userID":130636,"name":"Grace Tidwell","url":"https:\/\/community.smartsheet.com\/profile\/Grace%20Tidwell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-09-27T15:36:02+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-07-13T20:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":61,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/75195\/whats-wrong-with-my-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75195\/whats-wrong-with-my-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":75020,"type":"question","name":"Using Month\/Year in formula","excerpt":"Am I missing an easy way to pull in a count based off month in a chart? For ex. My chart shows July and I would like my formula to count events based off the July name in the chart (@row), I could only figure this out using a month helper column in my source sheet and having to manually adjust each formula? If I used 07\/20…","categoryID":322,"dateInserted":"2021-01-20T02:36:08+00:00","dateUpdated":null,"dateLastComment":"2021-01-22T22:42:24+00:00","insertUserID":123051,"insertUser":{"userID":123051,"name":"Autumn Bennett","url":"https:\/\/community.smartsheet.com\/profile\/Autumn%20Bennett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-10T12:53:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":126171,"lastUser":{"userID":126171,"name":"Mark Cronk","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Cronk","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/9UVGVH5TN00I\/nO060PSRF4UVU.jpg","dateLastActive":"2023-05-10T19:07:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":415,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/75020\/using-month-year-in-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/75020\/using-month-year-in-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"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":true,"noCheckboxes":false}">

Help Article Resources