Custom Formula for Progress Tracking in Jira Product Discovery

[Pradeep]

Hi Jira Community,

I’m trying to create a custom formula in Jira Product Discovery to track project progress based on three custom single-select dropdown fields:

• Schedule (Values: "On Track", "At Risk", "Off Track", "Needs Review")
• Scope (Values: "On Track", "At Risk", "Off Track", "Needs Review")
• Resourcing (Values: "On Track", "At Risk", "Off Track", "Needs Review")

I created a 4th column called Progress and attempted the following formulas.

IF(AND(Schedule = "On Track", Resourcing = "On Track", Scope = "On Track"), "On Track", IF(OR(Schedule = "Off Track", Resourcing = "Off Track", Scope = "Off Track"), "Off Track", IF(OR(Schedule = "At Risk", Resourcing = "At Risk", Scope = "At Risk"), "At Risk", "Needs Review") ) )

ISSUE : Could not parse expression issue is displayed. 

Questions:

1. Are dropdown fields referenced differently in Jira Product Discovery formulas?
2. Is there a better way to achieve either a status-based ?

Would appreciate any help.

Thanks, 
Pradeep

[Amina Bouabdallah · Accepted solution]

hi Pradeep! you will need to use automation for these advanced formulas, they cannot be used in custom formulas. Hope this helps!

[Pradeep]

Hi @Amina Bouabdallah Thank you for your response. I will try the automation and see how it goes. Thanks.