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

[Anand Chittoor]

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.

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 - 

[Dave]

That authentication requires a local JIRA administrator user and password, so if you're using Google to login, that password won't work.  If that's the case, when you first logged in with Google, you set a local password for JIRA; if you don't remember it you can log out and use the forgot password link to reset it, or reset your password directly through the user admin (this will not affect Google authentication).  

[rob damus]

spot on. thanks. btw, your username and email are not necessarily the same string.