Adding Contains to My Formula

Anthony Barthelemy

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

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

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

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

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