Automation rule not updating (shows no errors)

Question

Hi, I'm trying to create an automation rule.  I have two fields, first the due date, the other one is  a number (custom field).  And I want to to do this.

* Calculate the difference in days between now date and due date.
* Split the result with the number field.

I'm using this formula

{{now.diff(issue.fields.duedate).days/issue.fields.customfield_10104}}

Automation rule is not triggering any issue, but it's not updating the field.

Mykenna Cepek · Answer

You're in good hands with @Bill Sheboy and @John Funk

I'd just add that you might want to review how the math expression syntax works for Smart Values in automation (as documented here). The general format for math expressions is:

{{#=}} expr {{/}}

Automation can handle this kind of thing well, but the syntax and semantics of Smart Values will have you fussing with it until it finally works.

As for "not triggering" and "not updating", screenshots of your rule and the Audit Log will be helpful.

Bill Sheboy · Answer

Hi @Raúl Eduardo Echeverría Urbina

For questions on automation rules, please post images of your complete rule and the audit log details, showing the execution.  That will provide context for the community to offer suggestions.  Thanks!

From what you have shown thus far...

To perform division you may either use the slash and a mathematical expression, or just use the divide function, such as this:

Kind regards,
Bill

John Funk · Answer

Hi Raúl,

I would do that in two different steps to help with any troubleshooting.

Create another custom number field.

Update the new custom number field based on the diff of the two dates.

And then update the original number using the division.