Creating Calculated field by automation

Question

Hi,

I want to calculate the Time Spent on each ticket. The formula is:

Original Estimate - Time Remaining = Time Spent

May you help me with the Edit Issue (Time spent) in Jira Automation?

Thanks,

Maya

Sebastian Krzewiński · Answer

@Maya.herman

Please try use diff - https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/#Calculating-the-difference-between-two-dates

Maya.herman · Answer

Hi,

Thanks for the answer but it’s still not working for me.

The syntex i wrote:

{{#=}}({{issue.fields.originalestimate}} - {{issue.fields.timeremaining}}) {{/}}

the error I got:

Action details:
Edit issue
Error rendering smart-values when executing this rule:
Missing parameter(s) for operator -u: ( - )
Associated items:
Issue event
MCD-6362

thanks,

maya

Sebastian Krzewiński · Answer

Hi @Maya.herman

To achieve that:

* you need to use math expression in automation* https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/
* https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/

* how to get values from fields you can find here - https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/
* nece example how to use links above - https://community.atlassian.com/t5/Jira-Software-questions/How-to-access-smart-values-for-quot-Remaining-Estimate-quot-and/qaq-p/1362835

Regards,

Seba