You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
How is everyone using functions and formulas?
Do you have examples of your setup you can share?
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?
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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: https://www.loom.com/share/a09506455d6b4571a912567d5df4169b.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I use these to calculate scores (ICE, WSJF, Goal Impact/Effort, etc...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.