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

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

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
1 vote
Chris Hall Atlassian Team 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:

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

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

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events