IF THEN for product discovery formula fields

[Pat Mihelic]

I would like to define IF, THEN values driven by a multi-select dropdown. The goal is to add specific multipliers/weighting for each multi-select field. An example is customers and revenue.

The formula might look like {multiplier}*{reach}/{effort}  where the {multiplier} is driven by labels.

If Customer A label exists, multiplier equals 1.5. If customer A and customer B label exists, multiplier equals 1.5*1.2. If no label exists, multiplier equals 1. Etc. 

Is this possible with jira product discovery formulas?

[Bill Sheboy]

Hi @Pat Mihelic -- Welcome to the Atlassian Community!

I do not believe such conditional logic is supported for JPD custom formulas yet: https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/

As a workaround, you could use an automation rule, triggered on changes to your input fields, and using a lookup table for the mapping of multipliers.  For example:

• trigger: change to any of the input fields
• action: create a lookup table for the mapping
• action: edit issue, using a smart value, math expression with the table values as inputs

To learn more, please see this information:

• https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/
• https://support.atlassian.com/cloud-automation/docs/jira-automation-triggers/#Field-value-changed
• https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-lookup-table
• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

Kind regards,
Bill

[Pat Mihelic]

Okay great. Thank you for your response Bill! I will give that a try