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?

[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?

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

[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