Count only outstanding items

Gary Brown
Gary Brown ✭✭
edited 12/09/19 in Formulas and Functions

I have a Request Management sheet with a Form that we used to track tasks.  They template came with a Metric sheet that is very useful.  One of the metrics on this Metrics sheets counts items by assigned person.  I want to update that to count only items that are not Closed status.  Current formula is: =COUNTIF({Request Tracker Range 3}, Category20)   How do I update this to show only non Closed statuses?  The metrics are pulled into a graphic on a Dashboard. 


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!