Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Structures: using "resolved"/"resolutiondate" in column formula not working

Crads
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 13, 2024

I have a Jira structure that is returning Epic's under a certain condition which are extended to show issues belonging to Epics (Stories). 

Via a formula column i am trying to sum the number of stories completed within a certain time period and sum that number at the Epic level;

IF issuetype = "Epic":

SUM{IF issuetype = "Story" AND (resolved>08/05/2024 ) : 1}

 

I have also tried

 

IF issuetype = "Epic":

SUM{IF issuetype = "Story" AND (resolutiondate>08/05/2024) : 1}

 

While completed stories are being totalled correctly that date is being ignored, is the date format i am using incorrect, is there a better way?......

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
1 vote
Answer accepted
Stepan Kholodov _Tempo_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 13, 2024

Hello @Crads 

The Formula column processes dates as timestamps, so a custom date should be defined as one as well. To define a date, you can use the date() function like this:

if resolved > date("2024-05-08"): 1

I hope this helps. If you need further assistance or if you have more questions about Structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)

TAGS
AUG Leaders

Atlassian Community Events