COUNTIFS with criteria & exclusion


Hello, I am looking for help with a formula to determine how many files are assigned to a specific person that are not closed. The column names are listed below:

  1. [File Manager]
  2. [File Status]

I have a separate sheet for metrics that I am hoping to pull this data into and I have tried this fornula below:

Note - the Label@row contains the file managers name in a separate column)

=COUNTIF({File Tracker 1}, Label@row, (NOT(CONTAINS("File Closed", @{File Tracker 2}))

I get the error message #UNPARSEABLE

Any help is greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!