Count multiple criteria
Melitta
✭✭✭✭
I'm looking for a formula to count a single criteria from one cross sheet column and multiple criteria from another column. Any suggestions?
=COUNTIFS({My Sheet - Status}, "New Request"), {My Sheet - Unit}, OR(@cell = "Library", @cell = "MGEN", @cell="NuRes", @cell="OARS", @cell="ODEI", @cell="OTP", @cell="Registrar", @cell="UDS", @cell="Other")
Tags:
Answers
-
Try moving the closing parenthesis from after "New Request" to the very end of the formula.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!