CountIf and Exclude Status

edited 12/09/19 in Formulas and Functions


I am trying to count the number of requests types and exclude certain statuses. The current formula is: =COUNTIF({Request Tracker Range 4 - Request Type}, Category13).

I want to display the current number of Client or Internal requests and omit Completed or Declined.

Any suggestions are appreciated!

2019-08-28 16_33_39-(2) Sheet - Request Metrics - Smartsheet.com_.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!