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?