COUNTIFS with Jira links and Status
I am looking to count the number of open tasks from a smartsheet workflow from JIRA.
I have JIRA links marked 'ITV'= the reference from JIRA (for example ITV-123) and others using TPM-and the JIRA reference. In addition, I want to count all statuses marked as Open, In progress, etc,..
I am trying this formula but doesn't work
=COUNTIFS(JIRA:JIRA, CONTAINS(@cell"ITV"), Status:Status, "In Progress", "Open"))
Help Article Resources
Check out the Formula Handbook template!