Adding Contains to My Formula
Good Evening Smartsheet Community:
I am trying to count the number of Fail that Contain FSA in the Key, but I can not seem to get the last part of the Formula Correct.
Current Formula: =COUNTIFS({Test Env}, "Prod", {Test Status}, "Fail", {Key}, CONTAINS("FSA"))
Thanks
Best Answer
-
Genevieve P. Employee Admin
Hi@Ray B
TheCONTAINS function (see here)requires a range to be specified within it, along with the criteria. Since you already state the range before it, you just needto use @cellin order to tell the formula to look intoeach cellof the previously listed range.
Try this:
=COUNTIFS({Test Env}, "Prod", {Test Status}, "Fail", {Key}, CONTAINS("FSA", @cell))
(PS@Mark C.I think you may have pasted in the wrong formula? Looks like a great solution for someone else, though!)
Cheers!
Genevieve
Answers
-
Mark Cronk ✭✭✭✭✭✭
Hi@Ray B
Try:
=IF(AND([FINISH]@row< [Go live Date]@row), OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "At Risk")),1,0)
Work?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Genevieve P. Employee Admin
Hi@Ray B
TheCONTAINS function (see here)requires a range to be specified within it, along with the criteria. Since you already state the range before it, you just needto use @cellin order to tell the formula to look intoeach cellof the previously listed range.
Try this:
=COUNTIFS({Test Env}, "Prod", {Test Status}, "Fail", {Key}, CONTAINS("FSA", @cell))
(PS@Mark C.I think you may have pasted in the wrong formula? Looks like a great solution for someone else, though!)
Cheers!
Genevieve
-
Mark Cronk ✭✭✭✭✭✭
Ooooops! Sorry. Thanks@Genevieve P.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Anthony Barthelemy ✭✭✭✭✭✭
Ok, I tried that but it Resulted in Blocked. Logged Out of Smartsheet and back in and it worked. Has that anyone else Experienced that before?
Thanks
Help Article Resources
Categories
I hope you're well and safe!<\/p>
You must add\/change the Rule #1 name.<\/p>
Did that work\/help? <\/p>
I hope that helps!<\/p>
Be safe, and have a fantastic week!<\/p>
Best,<\/p>
Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p> ✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":443,"urlcode":"dynamic-view","name":"Dynamic View"}]},{"discussionID":108765,"type":"question","name":"Production Downtime Tracking - Crossing the Dateline","excerpt":"Thanks for taking the time to read this post. I am attempting to restructure my companies end-of-shift reporting system with smartsheet to facilitate better automated data processing. An issue i am currently dealing with is how to calculate the impact or \"Yield\" in minutes of line downtime as we cross from one day to…","snippet":"Thanks for taking the time to read this post. I am attempting to restructure my companies end-of-shift reporting system with smartsheet to facilitate better automated data…","categoryID":322,"dateInserted":"2023-08-09T21:31:26+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T13:35:07+00:00","insertUserID":148642,"insertUser":{"userID":148642,"name":"Isaac T.","url":"https:\/\/community.smartsheet.com\/profile\/Isaac%20T.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-10T13:46:22+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-10T16:10:59+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":35,"score":null,"hot":3383292993,"url":"https:\/\/community.smartsheet.com\/discussion\/108765\/production-downtime-tracking-crossing-the-dateline","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108765\/production-downtime-tracking-crossing-the-dateline","format":"Rich","lastPost":{"discussionID":108765,"commentID":390007,"name":"Re: Production Downtime Tracking - Crossing the Dateline","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390007#Comment_390007","dateInserted":"2023-08-10T13:35:07+00:00","insertUserID":45516,"insertUser":{"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-10T16:10:59+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-08-10T13:47:12+00:00","dateAnswered":"2023-08-10T10:14:42+00:00","acceptedAnswers":[{"commentID":389977,"body":"