Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,367,721
Community Members
 
Community Events
168
Community Groups

Assignee using Formula in structure

Hi,

I have a structure with one of column as Assginee, which I am able to pull the data into the structure.

If I'm trying to build a formula if there is an assignee and expecting to get the name of assignee against the issue type. If there is no assignee against to that issue type i want to populate 'No Assignee'. I am trying to use below formula but I am not getting the name of the assignee though assignee name is there against to that issue.

If(Assignee != "empty"; Assignee;
Assignee = "empty"; "No Assignee")

Appreciate any help here.

 

Thanks in advance.

 

1 answer

1 accepted

2 votes
Answer accepted

Hello @sarathgd ,

Are you receiving an error or the values are all "blank"?

Rather than saying "Empty", you will want to use undefined, like this:

If(Assignee != undefined; Assignee;
Assignee = undefined; "No Assignee")

I can't say for sure if it is the reason you are encountering an issue though.  What version of Jira and Structure are you currently using?  

Please feel free to contact our support team directly via email support@almworks.com or customer portal support.almworks.com.

Best,
David

Hi David, thanks for quick response.

I'm using Jira v8.20.10, OnPrim version.

With the above formula I'm able to populate No Assignee against issues if there is no assignee. For the issues if the issue have assignee also I am not getting the name of assignee but I'm getting value as JIRAUSER.

 

Appreciate your help here.

Like Dave Rosenlund _Tempo_ likes this

Hello @sarathgd ,

You are very welcome!  Thank you for the additional information!  

This modification should work:  

If(Assignee != undefined; Assignee.name;
Assignee = undefined; "No Assignee")

This asks for the name rather than the key when returning the value.

Hope this helps.

Best,
David

Like Dave Rosenlund _Tempo_ likes this

Thanks David, this logic worked :)

Like # people like this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Atlassian Community Events