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

Formula expression logic and operators

Hi, I've just discovered the JPD Beta and am already sold!

However I'm looking to do something that probably isn't possible yet in the Beta, but hoping the community can help or the someone can confirm if what I'm looking is on the feature roadmap. Also JPD Automation doesn't appear to work for me at the moment so haven't delved in to that area yet to see if I can do what I want.

I'm utilising the Formula Field, and writing a custom expression, however I want to be clever with how the formula is calculated based on the value of another field. In simple terms I want to use IF..ELSE logic in the expression (or the ternary JavaScript style IF..? :) to test a variable:

IF (a == true)
    {Value} * {Effort}
    {Value} / {Effort}

As mentioned I can't access the JPD Automation, so this may be possible using the features in there, but it would be really cool to have logic and operators in the formula field expression to get creative with that field.

2 answers

1 accepted

0 votes
Answer accepted
Hanna Atlassian Team Jul 26, 2022

Hi @Phil Middlemass

Thank you for this suggestion, currently, it's not possible to write a formula like this. I'll add it to the list of ideas for Jira Product Discovery. 


Thanks @Hanna 

As I can't access the Automation features right now, do you know if they are capable of achieving a simple IF..ELSE or are they not that advanced yet?

Hi @Phil Middlemass ,

I have access to automation on my JPD project, and it does have the 'if block' condition, so I am guessing you could potentially implement what you seek.


Thanks @Omer Meshar 

That looks promising, hopefully (could you check and confirm), the 'Create Variable' action is available too. If so then yes I/we should be able to implement this kind of calculation and field update through automation.


Like Phil Middlemass likes this


Just need my service request for Automation access in JPD issue to be resolved

0 votes

Hi @Phil Middlemass -- Welcome to the Atlassian Community!

Yes, and...I'd like to see the same thing (formulas) for filters in views in Jira Product Discovery.  The only work-around I can think of is adding custom fields solely for the purpose of filtering, and setting the values with automation rules.

Kind regards,

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events