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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the公式手册模板!
Hi @BristolCVN<\/a> <\/p>

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":"

Hi @Isaac T.<\/a> <\/p>

=([End HR]@row + IF([End HR]@row < [Start HR]@row, 12, 0)<\/strong>) * 60 + [End Min]@row - ([Start HR]@row * 60 + [Start Min]@row)<\/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":108747,"type":"question","name":"Need help calculating estimated completion date for production while excluding weekends","excerpt":"Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders based on a few criteria. A few things are missing that are confidential, but I have attached a picture of a practice spreadsheet: Please note: a…","snippet":"Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders…","categoryID":322,"dateInserted":"2023-08-09T17:13:03+00:00","dateUpdated":"2023-08-09T17:48:49+00:00","dateLastComment":"2023-08-10T15:42:42+00:00","insertUserID":157351,"insertUser":{"userID":157351,"name":"Taylor Mauzy","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20Mauzy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/42XXKDZ40O1H\/nTN7AUSB0JQCG.jpg","dateLastActive":"2023-08-10T16:31:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":157351,"lastUserID":157351,"lastUser":{"userID":157351,"name":"Taylor Mauzy","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20Mauzy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/42XXKDZ40O1H\/nTN7AUSB0JQCG.jpg","dateLastActive":"2023-08-10T16:31:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":51,"score":null,"hot":3383285745,"url":"https:\/\/community.smartsheet.com\/discussion\/108747\/need-help-calculating-estimated-completion-date-for-production-while-excluding-weekends","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108747\/need-help-calculating-estimated-completion-date-for-production-while-excluding-weekends","format":"Rich","tagIDs":[219,254],"lastPost":{"discussionID":108747,"commentID":390048,"name":"Re: Need help calculating estimated completion date for production while excluding weekends","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390048#Comment_390048","dateInserted":"2023-08-10T15:42:42+00:00","insertUserID":157351,"insertUser":{"userID":157351,"name":"Taylor Mauzy","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20Mauzy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/42XXKDZ40O1H\/nTN7AUSB0JQCG.jpg","dateLastActive":"2023-08-10T16:31:11+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/0MW6TRZ3P75E\/primary-production-example-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Primary Production Example.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T15:42:57+00:00","dateAnswered":"2023-08-09T19:41:02+00:00","acceptedAnswers":[{"commentID":389887,"body":"

@Taylor Mauzy<\/a> <\/p>

I believe this will work based on your ask.<\/p>

In your Expected Days to Completion, you need to use a round formula to make it a whole number.<\/p>

=Round([Work Order QTY]@row - [Current FG Units]@row) \/ [Planned QTY\/Hour]@row) \/ [Hours Per Day]@row,0)<\/p>

Then in your Est Completion Date, you should be able to use<\/p>

=WORKDAY([Scheduled FPA]@row, [Expected Days Until Completion]@row)<\/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":219,"urlcode":"Sheets","name":"Sheets"},{"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":[]}">

Trending in Formulas and Functions