Structure: How do I use the function USER_DISPLAY_NAME with a username?

Diana Gorv

I'm trying to make a Formula column that will display the full name from a Notes column where I type in their username.

See screenshot example:

Basically, "Notes" column is a place to add points of contact users but aren't assigned to or are reporters of the issue, so we use the Notes column and map it to the Formula column to display their name. Then the ultimate goal would be to Group by Formula. Is there something wrong with how my formula is written?

This is a test example, so "usera" is the username with "User A" is their full name. Same for "userb"

EDIT: also adding that "usera" and "userb" are active users

Stepan Kholodov

Hello @Diana Gorv 

The Notes column contains text or numeric values only, and in your case it looks like you want to reference the actual user attribute, and access one of its properties (name). This is not possible to do this way. You can use the formula:

if issuetype = 'Story" : notes

and display 'usera' or 'userb' - the exact values that exist in the Notes column - but if you want 'usera' to be interpreted as a user with user name 'User A', then you need to reference either a different column or a relative field that has this attribute. For example, if an issue has 'usera' as Assignee, you can extract the name through the field like this:

if issuetype = "Story" : user_display_name(assignee)

I hope this helps. If you need further assistance or have other questions about Structure, please reach out to us directly at our support portal and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)