Image.png
I have apps A, B, C, D with different issue ID's, open dates, status, and closed dates (if closed).
A closed issue might show up on the ALL tab and closed tab, until the ALL tab has been updated.
I'm trying to make a dashboard and want a count of the issues that have had an open status this tracked year (10/1/18-9/30/19). So either open now (blank closed date) or closed after 9/30/18.
I do not want to include Issues with IDs that have Iss or Wro in the name.
Is there a formula that can count unique issue ids for app *, excluding iss and wro issues, that have had an opened status within the tracked year (10/1/18-9/30/19).
Bookmarks