Automation: Add multiply a custom field and add it like days to a date field

[Facundo Castillo]

Hello, I have a problem that I cannot solve. I've been looking around the community and I haven't found a solution.

I have 2 fields:

• Numeric type: "Number Flag"
• Date Type: "Due Date"

---

When a issue is created i need to edit the field "Due Date" adding days:

• "Due Date" plusdays ( "Number Flag" * 10)

Example:

• 05/07/2022 + (2 * 10) = 25/07/2022

---

Any recommendation? Thanks!!!

[Aditya Sastry · Accepted solution]

Hi Facundo,

Please try the below syntax in Project Automation 

{{issue.dueDate.plusDays(Number Flag.multiply(10))}}

Below is a screenshot of the section. I have used "Feature Ranking" a numeric field in my instance.

[Facundo Castillo]

Thanks for the help, i finish the problem with an hybrid with your answer and John,

Result:
{{#issue.Payment Date}}func=plusDays({{Number Flag.multiply(10)}}){{/}}

[John Funk · Accepted solution]

Hi Facundo - Welcome to the Atlassian Community!

You should be able to do this with an automation rule.

When you update the Number Flag or Due Date field, you will use a syntax like this:

{{#triggerissue.duedate}}func=plusDays({{issue."Number Flag" * 10}}){{/}}

Give that a whirl and let's see what happens - hopefully I have the syntax correct. 

[Facundo Castillo]

Thanks for the help, i finish the problem with an hybrid with your answer and Aditya, because * doesnt work in this query.

Result:
{{#issue.Payment Date}}func=plusDays({{Number Flag.multiply(10)}}){{/}}

[John Funk]

Great!

[Kian Stack Mumo Systems]

Try to follow this documentation on math expressions. Have you already tried any of these?