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?
LinkedIn
Twitter
