nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation for Jira DC smart value formula not working

Lior Efraim_yw4e72

Hello,

i have a field called "Start Date", a date field (no time)

another field "Sprints Estimation" which is number field.

i want to set a value of another date field - "Finish Date" to be:

Finish date = Start date + (Sprint estimation) * 21

this is what i tries and getting error parsing from automation:

option 1: {{#=}}{{issue.startDate.plusDays({{issue.sprintsEstimation}} * 21)}}{{/}}

option 2: {{issue.startDate.plusDays({{#=}}{{issue.sprintsEstimation}} * 21{{/}})}}

any ideas?

thanks im advance to any answer.

Accepted answers

Lior Nesher

Hi Lior,
One small correction you used custom field "Start Date" and call it to "StartDate" you can use the space.
that error might be happen again in @Bill Sheboy solution isn't worked for you, you used 'sprintsEstimation' together, and my guess the field called 'Sprints Estimation'.

{{issue.Start Date.plusDays(issue.Sprints Estimation.multiply(21))}}

to avoid those kind of mistakes my tip is using the custom field id

{{issue.customfield_xxxxx.plusDays(issue.customfield_xxxxx.multiply(21))}}

All comments

Bill Sheboy

Hi @Lior Efraim

Please review the math expression syntaxes, and then try this one:

{{issue.startDate.plusDays(issue.sprintsEstimation.multiply(21))}}

And, when using a smart value nested within another function, the extra curly brackets are usually not needed.

Kind regards,
Bill

Lior Efraim_yw4e72

Thank you Bill.

result is "success" from the automation, and "Issues edited successfully" but "Finish Date" stays empty.

i tried add "jiraDate" to the statement as i saw in documentation:

{{issue.startDate.plusDays(issue.sprintsEstimation.multiply(21)).jiraDate}}

but still same thing, i get success with no value in the field it stays empty.

Kelly Arrey

Hi @Lior Efraim can you show us the details of the part of the rule where you set the Finish Date value? Thanks!

Lior Efraim_yw4e72

sure. please see screenshot

Lior Nesher

to avoid those kind of mistakes my tip is using the custom field id

{{issue.customfield_xxxxx.plusDays(issue.customfield_xxxxx.multiply(21))}}

Lior Efraim_yw4e72

Thanks Lior!

what worked for me was:

{{issue.Start Date.plusDays(issue.customfield_17909.multiply(21))}}

just need to remember changing the number in customfield_xxxxx when moving this to prod.

thanks again!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

automation

smart-value

formula