Hi all,

I am trying to create a formula in my sheet summary that calculates total number of tests passed for a given month. I have already created syntax for "Total Samples Passed Today", but the month criteria keeps coming back as an error when I add it in. :( Total samples passed today looks like this: =COUNTIFS([Retest Result]:[Retest Result], "Pass", [Retest Date]:[Retest Date], @cell = TODAY()) + COUNTIFS(Results:Results, "Pass", [Final Date]:[Final Date], @cell = TODAY())

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!