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

Find more posts tagged with

Accepted answers

Genevieve P.

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

All comments

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

Genevieve P.

Hi @Ray B

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.