Creating Calculated field by automation

[Maya.herman]

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]

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

[Maya.herman]

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]

@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