Assignee using Formula in structure

[sarathgd]

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.

[David Niro · Accepted solution]

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

[sarathgd]

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.

[David Niro]

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

[sarathgd]

Thanks David, this logic worked :)