Calculation the time between start date and due date

Question

Hi, I created an automation with smart date and time values,

I want to calculate the time from start date or begin date to end date/(now in automation).

I have created several smart value queries but none of them work.

Any ideas what I should change.

Bill Sheboy · Answer

Hi @bartlomiej.jochym Adding to the answer from @Kalyan Sattaluri ... Would you please explain some things about your rule: * Why does this rule move all of the linked issues to Completed when one issue moves to Done? * Which issue are you trying to measure for: the trigger issue, the linked issues, or both? * For the fields you are using for the measures, what are their types: date, date / time, text, etc.? * For the fields you are using for the measures, have you confirmed the smart values for those fields? On the last point, smart values are name, spacing, and case-sensitive. And often the smart value does not match the displayed field name on the issue views. The how-to article below helps to identify the correct smart value (and custom field id) for any supported fields for automation rules. The essential steps are: * identify an issue which has your field(s) * call a REST API function with a browser to search for your issue: https:///rest/api/2/issue/?expand=names * search on the page for your field, such as with CTRL-F* if you find the field, you will also find the smart value, custom field id, and structure / attributes it has * if you do not find the field, it is not supported by automation rules https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/ Kind regards, Bill

Kalyan Sattaluri_iinm1n · Answer

When you are inside the branch use {{triggerIssue}} instead of {{issue}} to reference the original tickets data.

Also always good idea to log these smart values outside of branch first referencing {{issue}} first to verify.

Then log the same values inside branch but by using triggerissue reference instead of {{issue}}