COUNTIFS and NOT Function
Silvia Frei
✭✭✭✭
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
-
Hi,
this works for me:
=COUNTIFS(JIRA:JIRA, CONTAINS("TPM", @cell), [Issue Type]:[Issue Type], ="Epic", Status:Status, <>"Closed", Status:Status, <>"Done")
For you too?
Greetings
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.
-
Perfect! Thanks :)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!