Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

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!


Missing exponent function in a custom forumla (=power of n)

I just love product discovery! Lately i'm automating calculating priority of ideas. I'm doing this based on 'Custom Formula' fields with 'write your own' expressions.

I have found the page that describes what we can do with expression based forumlas:

I'm however really missing the option to do x to the power of n (x^n):

Why do i need it:

The field weights are ranged 0 to 5 (with 0 the field not being filled).
To make higher values worth more, I need to move from a linear set of values to an exponential set.

Consider the readability of my current solution vs my preferred solution: 




{__impact_0to1} * (1 - {__effort_0to1} ^ 4 )


Perhaps this is possible already but not documented, or done differently.

In that case, please tell me how to do this. If not, perhaps add it to the backlog?

1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
2 votes
Answer accepted
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Nov 25, 2022

thanks for the feedback @Daniel Rijkhof , I don't think there's a way to do that today but we'll consider it when improving formulas 

Thanks for the quick reply.

I hope the request to add power of n (x^n) to the options for formulas makes it onto some high priority quick wins list. It cannot be that much work can it 😇



We'd appreciate a power function, as well. Currently, we're multiplying a lot ... ({effort}*{effort}*{effort} ... ;-))

To do cool stuff we just need that.

Here some examples that are doable with a ^:

Low end boost (low_end_boost: 4)





High end boost (high_end_boost: 3)




Double boost: (high_end_boost and low_end_boost at 3)



This last example is currently impossible. 

Depending on the distribution of values the last formula can really effectively distribute idea's in a matrix view nicely...

Like Jan-Hendrik Spieth likes this
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Nov 29, 2022

Oh. My. God. Are we still talking about product management and prioritization? 😅 I'd love to chat to understand how that works in your company because there seems to be a hell of a lot more science than what I've seen so far.

Like Steffen Opel _Utoolity_ likes this

I'm very much open to discuss this topic with you! How can we set it up?

Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Mar 02, 2023

@Daniel Rijkhof by the way you can now give custom weights to options in a select/multi-select field (not just use a 1-5 rating but use any number you like in there). 

I remember you wanted this pretty badly. let us know if that helps!

Like # people like this

@Tanguy Crusson 
I've created both a new select and a new multi-select field but failed to find a way to configure specific values...

I can only find the way of selecting 0 to 5 *stars.

Please enlighten me 😇

*more like dots...

Jan-Hendrik Spieth
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.
Mar 13, 2023

@Daniel Rijkhofare you looking for this?

Screenshot 2023-03-13 083558.png

Like Tanguy Crusson likes this

Thanks @Jan-Hendrik Spieth . That is what i was looking for. Somehow i missed it...

Like Jan-Hendrik Spieth likes this
AUG Leaders

Atlassian Community Events