COUNTIF formula

edited 06/14/22 in Formulas and Functions

I'm trying to add a formula to a metrics sheet to count the number of issues by both a project name name and status. Project name and Status are columns in the worksheet I'm referencing.

In this case the project is called DREAM and the primary column on my the metrics sheet lists the options resolved and unresolved

I tried this but it's giving me #incorrectargumentset

=COUNTIF({Study}, "DREAM", {Status}, [Primary Column]@row)

Any suggestions on how to write this properly?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!