JIRA structure formula returns transaction date Status1 if not then Status2

[Iryna Notkina]

Hi,

As a result of the custom formula in the structure I need to get the date when the issue was in status1, if this issue was not in status1 at all I need to see Status2.

My formula looks like this:

With Display1 = IF Issuetype = "story" and LastTransitionToINPROGRESS !=0 : CONCAT(FORMAT_DATETIME(LastTransitionToINPROGRESS;"dd.MM.yyyy")):
With Display2 = IF Issuetype = "story" and LastTransitionToINPROGRESS =0 : CONCAT(FORMAT_DATETIME(LastTransitionInCodeReview;"dd.MM.yyyy")):

Concat ( Display1, " ", Display2)

// I use "transition date" for the variables

But I get only the date of status1 or EMPTY

Thank you in advance

[Stepan Kholodov _Tempo_ · Accepted solution]

Hello @Iryna Notkina 

You can try a formula like this:

with Display1=CONCAT(FORMAT_DATETIME(LastTransitionToINPROGRESS;"dd.MM.yyyy")):
with Display2=CONCAT(FORMAT_DATETIME(LastTransitionInCodeReview;"dd.MM.yyyy")):

if issuetype = "story":
if LastTransitionToINPROGRESS: Display1 else
Display2

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Iryna Notkina]

Thank you a lot! It works