Tricky question - Who's up for the challenge?

[Colleen Gotling]

First of all, I probably can do this with scriptrunner but we do not have that tool so looking for another option.  

I created a custom field that will be used on both epics and stories.  I want to be able to show the Epic Name in this field so that when I run a query, I can sort by this field and I will see the Epic then all the stories under that Epic, then the next Epic and all the stories, etc.

I thought I would be able to use the Epic Name or Epic Link field but the Epic Name is only populated on the Epic and the Epic Link is only populated on the story so sorting does not work.  Therefore, I need to create a formula for this new field.  Something like

If Epic then "new field" = "Epic Name" else "Epic Link".  (a little more fancy than that but I'm sure you get the point).  I can't seem to figure out how to create a formula for a field or how to use automation to get this field to populate.  

Any ideas?

[Gideon Nolte _Eficode_ · Accepted solution]

Hi @Colleen Gotling

I hope to have understood you correctly.

Have you tried something like this already:

Once an issue is created, copy the field value from "Epic Name" (if its an Epic) or "Epic Link" (if its a Story) to a custom field of type label (Related Epic in this case).

To setup the "Edit Issue"-Action, use Smart Values like this:

Hope this works for you. Let me know if this solved it for you or whether you ran into any troubles. 

Greetings

Gideon

[Colleen Gotling]

I will give it a try.   Thanks!

[Colleen Gotling]

THANKS THAT WORKED!!!!

[Gideon Nolte _Eficode_]

@Colleen Gotling  Glad to hear that. Would you mind voting for and accepting my answer?