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.
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.
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:
{{now.diff(issue.duedate).days.divide(issue.customfield_10104)}}
Kind regards,
Bill
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.