Smartsheets Countifs and Month filtering Error


Hello Smartsheets community,

I am having some trouble with this code as I am not getting the answer I want. Any help would be appreciated!

=COUNTIFS({CBOM - Yellowstone Range 1}, "N", {CBOM - Yellowstone Range 2}, "1", {CBOM - Yellowstone Range 8}, "MONTH(@cell) = 9")

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!