Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Jira Automation - Smart value: Difference between 2 timestamp custom fields in a 3rd custom field

Anand Chittoor
November 2, 2021

Hello, 

Looking for some help here. 

I have researched many community solutions (by @Ravi Sagar _Sparxsys_ , @John Funk, and @Nir Haimov  but still stuck at the last hurdle.

I have the following custom field's below for which automation is working fine. These are timestamp fields.

I want to populate another custom field (number) Time to First Reponse (TTFR), which is the difference between the "Acknowledged timestamp" and "Ready status timestamp", ideally in businessDays. Hours will work too if need be.

Screen Shot 2021-11-02 at 10.04.12 AM.png

I have tested my automation conditions trying to hard code the TTFR edit issue to a number (2). and it populates fine. But when I insert the below formulae, the automation log shows success, but there is nothing outputted in the TTFR field.

-Formulae i have tried under "edit issue" 

  • Acknowledged Timestamp - customfield_14475,
  • Ready Timestamp - customfield_14474

{{issue.Customfield_14474.diff(issue.customfield_14475).hours}} 

or

{{issue.customfield_14475.diff(issue.customfield_14474]).businessDays}}

 

SCREENSHOTS - 

Screen Shot 2021-11-02 at 10.07.56 AM.png

2 answers

1 accepted

0 votes
Answer accepted
Hugo Emond
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!
July 5, 2011

My Greenhopper version is 5.4.1 but looks like I needed Jira 4.3.

I was hoping it would work anyway but it doesn't.

Since it'a a versionning issue, I will ask my admin for an upgarde.

Thnak you for your time!

1 vote
Azwandi Mohd Aris
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Champions.
July 5, 2011

The wallboard plugin is using link provider module, offered by GreenHopper plugin. GreenHopper introduced this module since it's version 5.3 (as stated in the documentation you were looking at), hence, you might want to check that you have this version (or newer) in JIRA.

Suggest an answer

Log in or Sign up to answer