COUNTIFS formula that excludes items with a certain status

Kristine Fachet
Kristine Fachet ✭✭✭
edited 07/27/21 in Formulas and Functions

Hello! I want to create a graph that shows current Creative requests by department. I currently have a metrics sheet that is counting the total number of requests by department with the below formula, but I want it to exclude any projects where the status is "complete".

Here's the formula I currently have:

=COUNTIFS({Creative Services Tracker Requesting Dept}, Description@row)

The brackets are referencing another sheet: Creative Services Tracker = sheet name; Requesting Dept = column to count.

There is another column of the referenced sheet named "Status" that would have the project status to check against.

Thanks in advance for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!