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!


How is everyone using functions and formulas?

How is everyone using functions and formulas?

Do you have examples of your setup you can share?


4 answers

Suggest an answer

Log in or Sign up to answer
3 votes
Chris Hall
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
Jul 20, 2022

Hi @Erin Mihalik! One use case for custom formulas is to calculate a RICE score. Here's a demo of how to set it up:

Jaime Capitel _resolution_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Jun 29, 2023

I was trying RICE with a number for reach but it makes it so skewed when everything else is a rank. Thanks for this!

1 vote
Deleted user Jul 25, 2022

I'm using a combination of a bunch of calculations I had in different spreadsheets all over the place to smoosh together weights and scores and formulas. It brings together these frameworks and more...

My stakeholders are getting excited about this already, and hey, that's half the battle, right?

Screen Shot 2022-07-25 at 4.26.16 PM.png

Congrats on the stakeholder win, this view must have helped!

I've been playing with some patchwork methods myself to find a better balance. EG adding a goals booster to a RICE model but without multiplying the number again. Seems the balance of the formula and input ranges is key... I wouldn't mind seeing how you assign % weights and /100 score in the Jira formula bar?

Like Chris Hall likes this

@Oliver Murray @Chris Hall - do you know how the (now deleted user) above got to assign values to fields (so for example fields like customer pain, t-shirt size, roadmap) have values assigned to them that feed into the fx formula? I can't seem to replicate this or perhaps I'm just missing something obvious! Thanks

@Ted looks to me like they have used a select or multi-select field but changed the weightings. JPD then brings up the total SUM of weightings for selections in a number bubble within the cell. This total number does not appear unless you have custom weightings added.

To apply weightings, start editing the field and additionally use the small 'edit weighting' option that appears on the right above your custom selections.

Thanks @Oliver Murray - that was it! Fixed, and now our PO's are getting excited to create all kinds of weighted formulas. 

Like Oliver Murray likes this

I use these to calculate scores (ICE, WSJF, Goal Impact/Effort, etc...)

1 vote
Chris Timms
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.
Jul 20, 2022

Currently, we are not using them. We think we can use them to drive some impartial prioritisation in the future, but right now are focusing on driving stakeholders to make leaving feedback on the idea a habit in the first place, so that when we do turn on formula driven fields, they have good data backing them up.

Potential use cases would be to track effort/impact or insight/effort but I imagine our use would evolve when they are in place.

- C

AUG Leaders

Atlassian Community Events