COUNTIFS and NOT Function

I'm looking to count the number of instances an epic is listed, but to exclude Closed and Done ones.

I am trying this formula which gives an error

=COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], "Epic", NOT(Status:Status, "Closed", "Done"))

Any suggestions?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!