How is everyone using functions and formulas?

[Erin Mihalik]

How is everyone using functions and formulas?

Do you have examples of your setup you can share?

[Chris Hall]

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. 

[Jaime Capitel _resolution_]

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

[Deleted user]

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...

• Priority Matrix
• WSJF
• AAARRR Metrics

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

[Oliver Murray]

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?

[Ted]

@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

[Oliver Murray]

@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.

[Ted]

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

[sharon.prajzner]

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

[Chris Timms]

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