CountIf with Multiple Criteria + Mutli-Sheet Reference



I am trying to count total items in "Medium" item in PRIORITY Column that also have a status of "Done" in the STATUS Column. Both PRIORITY and STATUS columns are in the SCRUM: Communications sheet.

Here's my current formula (which is reciving a #INCORRECT ARGUMENT SET error):

=COUNTIF({ SCRUM: Communications PRIORITY Column}, "Medium", { SCRUM: Communications STATUS Column}, "Done")

Any pointers?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!