Show a value of a referenced row in a ref column instead of it's label

[Muhammad_Salooj]

How can I Show a value of a ref column instead of it's label, there are some views where I need to show only specific columns of the row Ref by the Ref column. I cant change the label because I require in in some views displayed as that.

I want the ref column-when selecting the ref rows  - IN THAT COLUMN ENUMLIST of base type REF to show only the User table Full name instead of the full label which is a concatenate of longer values incl meta data which I require in some other views as the row label.

I've read these articles: https://support.google.com/appsheet/answer/10107396

and https://support.google.com/appsheet/answer/11618586

Specifically, I  have used this formula but want a value instead of the label it outputs:

ORDERBY(SELECT(app_users_active_slice[unique_user_id], ([user_active_or_deactivated] = "active")), [full_name], false)

[Steve]

There is no way to display any other value except the label.