Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Adding a Numerical Custom field to a Due Date using smart values


We have a 3rd part provider who provides estimated for work. These estimated exclude business days. We have to update the due date on planned work a lot in jira roadmaps which creates a lot of overhead and admin when the plan changes

The logic I'm trying to create is 


Sprint start date + Size + Business days = Sprint Due date

Size is a custom numerical field, {{issue.fields.customfield_11714}} 


I've tried the new syntax 


This works when there is a static value in ()


However I cant get this to work when there is a variable 


I've also tried the above where customfield_11714 is created as a variable 

I found this article with a work around using an old syntax but the solution no longer appears to work 

{{#issue.field}}func=plusBusinessDays({{yourVariable|numeric field}}){{/}}


I'm now down to creating this as the mother of all if statements setting the date using static values based looking up using jira automation 

IF Size =1 {{Issue.Sprint.startDate.jiraDate.plusBusinessDays(1)}}

IF Size =2 {{Issue.Sprint.startDate.jiraDate.plusBusinessDays(2)}} 

etc. But this is obviously ugly as sin. Has anyone got a nicer solution?




1 answer

0 votes
Jack Brickey
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 14, 2023

Hi John, I can't get to where I can test out some automation at the moment. However, I'm wondering if the following might work.

create a variable action component, e.g.

size = {{issue.customfield_11714}}

then use the variable in your smartvalue statement 


Hi Jack 

I'm afraid not, I tried this,(probably wasn't clear enough in my explanation)

I've also tried the above where customfield_11714 is created as a variable 

Where the static version returns a date, this just blanks the value in the field its being returned to 

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events