Basic Math operations in custom formulas ?

TP
Contributor
July 4, 2023

I am trying to get an idea of the number of sprints I'll have to spend on a feature based on person-days estimates of several teams.

I want to approximate this value by taking the biggest number of sprints that each team will have to spend on it

 

Team 1 30 person-days = 3 Sprints

Team 2 20 person-days = 1 Sprint

Team 3 60 person-days = 2 Sprints

I would like the result to be 3 Sprints and the way you would calculate it is 

Max(Sprints Team 1, Sprints Team 2, Sprints Team 3)

 

Is this planned in the near future ? I have to export into excel to do this which I would like to get rid of...

1 answer

0 votes
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 5, 2023

Hi @TP 

Are all of the fields you note in your Jira Product Discovery (JPD) project?  If so, it does not appear there is a max() function for custom formulas in fields yet.

Have you considered using an automation rule in your project to set the field?

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events