How can I bring the label value from my ref into a concatenated Virtual Column?

I have a [Status] column that is a reference to another table that just converts numbers to text and allows my users to create their own status values/change what it says for a particular status. I want to have a header in my details view that is Label of status and Current Application date combined. If I just [Status]&" "&[Application Date] I get โ€œ5 8/20/2020โ€ instead of โ€œReviewing 8/20/2020โ€.
I know this is the valid behavior but is there a way to get the label when Iโ€™m using the value somewhere else instead of having a lookup to get the label?

Solved Solved
0 6 1,379
1 ACCEPTED SOLUTION

Donโ€™t forget the period for the dereference.

[Status].[LabelColumn]&" "&[Application Date]

View solution in original post

6 REPLIES 6
Top Labels in this Space