Adding Cross Reference Formulas

Smartsheet Community:

I am not sure what I am doing wrong here, but I am trying to count across multiple sheets when multiple criteria has been met. I think my parenthesis may be incorrectly placed, but Here is my existing formula:

=COUNTIFS({Gwen Pas/Fail}, OR(@cell = "Pass", @cell = "Retest Pass")) + COUNTIFS({Rita Pass/Fail}, OR(@cell = "Pass", @cell = "Retest Pass")) + COUNTIFS({Jason Pass/Fail}, OR(@cell = "Pass", @cell = "Retest Pass")) + COUNTIFS({Mike Pass/Fail}, OR(@cell = "Pass", @cell = "Retest Pass")))))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!