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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!