Adding Contains to My Formula

Options

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 Formula Handbook template!