Peta✭✭

0 and when \"Date\" column CONTAINS or FIND \"January\" Therefore if I only selected the first six rows as example, the SPI Quantity cell would return the value of 4. I tried this formula, however didn't work…","categoryID":322,"dateInserted":"2020-01-30T23:03:39+00:00","dateUpdated":null,"dateLastComment":"2020-02-04T12:08:31+00:00","insertUserID":45481,"insertUser":{"userID":45481,"name":"Peta","url":"https:\/\/community.smartsheet.com\/profile\/Peta","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!uvnOtxinljw!geVM4IDcDgQ!hffRGLIcWnW","dateLastActive":"2022-11-27T19:41:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":117588,"lastUser":{"userID":117588,"name":"Jayesh Nathani","url":"https:\/\/community.smartsheet.com\/profile\/Jayesh%20Nathani","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/146\/nTXYHAA94OW5V.jpg","dateLastActive":"2021-04-14T14:46:07+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":92,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/65660\/countifs-contains-or-find-formula-help","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/65660\/countifs-contains-or-find-formula-help","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/707\/TIJJRK0UFH0G.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.JPG"},"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":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}">