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
-
Hi @Ray B
The CONTAINS 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 need to use @cell in order to tell the formula to look into each cell of 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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
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.
-
Hi @Ray B
The CONTAINS 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 need to use @cell in order to tell the formula to look into each cell of 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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Ooooops! Sorry. Thanks @Genevieve P .
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!