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"))

Any suggestions?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!