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

"Custom Formula" to calculate a date

Sofia Rios March 14, 2024

I need to calculate a date field using another date field:

 

For example:

Launching Date = Delivery Date + 7 days

 

So when someone adds the "Delivery Date", automatically the "Launching Date" field is calculated. 

Is this possible? 

 

3 answers

Suggest an answer

Log in or Sign up to answer
2 votes
Daniel Naumann March 17, 2024

Hi Sofia,

An Atlassian team discussed how they used JPD and included the automation details on how to create a date in the future (+ X days) - https://community.atlassian.com/t5/Jira-Product-Discovery-articles/How-one-team-in-Atlassian-uses-Jira-Product-Discovery/ba-p/2452156

You'll want to check out part 3. I'm sure you can modify it to achieve your goal.

Sofia Rios March 19, 2024

Thank you!! This works :)

Like Daniel Naumann likes this
Daniel Naumann March 19, 2024

Oh, something to watch out for @Sofia Rios , is that any calculations the automation does (like triggering an action based on the date) are based on UTC time, but actions _you_ take are based on your timezone set in your profile.

It took me days to figure out why my automation wasn't triggering at the right time!

1 vote
Pieter Helsen March 15, 2024

Hi,

I would use an automation for that. 

See my example below:

Screenshot 2024-03-15 093920.png

Disclaimer: I did not activate and test the rule, but something similar should work.

Have a look at the Automation documentation if it doesn't work:

Jira smart values - date and time | Cloud automation Cloud | Atlassian Support

Hermance NDounga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 15, 2024

I don't think this workaround would work because date fields don't have this format in Jira Product Discovery :/ 
But then maybe using it it JSW  and then grab this date to Jira Product Discovery

Sofia Rios March 15, 2024

Thank you for your response. I tried it,  but it didn't work. It doesn't show me the fields I need to update (custom fields). 

0 votes
Hermance NDounga
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
March 15, 2024

Hi Sofia, 

Formula fields cannot calculate dates. 

If Pieter workaround works, I suggest you create this rule in your Jira Software project, so you get both dates, the Launching date and the Delivery date in Jira Software. 

Then you create a date field in Jira Product Discovery and you select "Ovveride values" in the field configuration, and you grab the value "Launching date" from Jira Software. 

If you can try it out, let us know if it worked!

Cheers,

 

Sofia Rios March 15, 2024

Thank you for your response. I tried Pieter's suggestion and it didn't work.

The issue is that both dates are custom fields within Jira Product Discovery.  It's sort of a GTM pipeline, so I really can't connect to Jira Software. 

TAGS
AUG Leaders

Atlassian Community Events