Leveling Priority Formulas

[Bill]

I am trying to create a structure formula for leveling priority across many epics.  I've started my formula by assigning priority to issues within a single epic using variables.  For example:

   IF type != "epic" AND variable1 = "a": 3000

   ELSE IF type != "epic" AND variable1= "b": 2000

   ELSE IF type != "epic" AND variable1 = "c": 1000

I would like to incorporate epic rank into the formula, such that when there is a conflict from "like" issues across epics, they are resolved according to the epic rank (ranked higher = higher priority).  

[Ste Wright]

Hi @Bill 

Is this linked to your other question?

If no - how would you determine which Epic should come first, if there's more than 2 variables?

Ste

[Bill]

Hi @Ste Wright yes they are related.  So for example if two different epics had conflicting/overlapping tasks like variable1 = "a" on the same day (so they had the same priority), I would like to push out the task in the lower ranked epic.  Rank = a sequential index in our context.

[Ste Wright]

Hi @Bill 

IF/ELSE statements in Automation will allow for this.

Not sure I'm across the exact need or each component; I'd do some trial and error and see how it goes!

Ste