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:
- [File Manager]
- [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.
