Adding Cross Reference Formulas

Anthony Barthelemy

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

Thanks

Anthony Barthelemy

Smartsheet Community I figured it out, one too many Parenthesis.

Genevieve P.

Hi Ray,

I'm glad to hear you figured it out! Thanks for posting your solution.

Cheers,

Genevieve