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! Go to Solution.
Donโt forget the period for the dereference.
[Status].[LabelColumn]&" "&[Application Date]
User | Count |
---|---|
43 | |
30 | |
26 | |
14 | |
14 |