Trouble with column references not displaying as expected

[elan_Bailey]

Hi I’m having issues with referenced columns not displaying as expected.

In this case I have a table called Check ins.
I’ve used a virtual column to create a unique title. In the past I concatenated a Text term with the extracted Month, Day and Year of when the reflection was created but I ended up with duplicate titles.

So now I want to use the value of a column [Commitment] which is a ref column along with the extracted Month, Day and Year.

Screencast.com

2020-05-21_11-55-03.png

Shared from Screencast.com

It works for the most part. But the value of [Commitment] is coming back with the key value, instead of the text column that I have chosen as the label for that table. Any ideas on how to override this?

Screencast.com

2020-05-21_11-54-08.png

Shared from Screencast.com

Screencast.com

2020-05-21_11-55-57.png

Shared from Screencast.com

[Jonathon]

Does this work:

CONCATENATE(
  "Reflection on ",
  [Commitment].[Commitment],
  " for ",
  TEXT([Created], "mm/dd/yyyy")
)

[elan_Bailey · Accepted solution]

Jonathon:

CONCATENATE(
  "Reflection on ",
  [Commitment].[Commitment],
  " for ",
  TEXT([Created], "mm/dd/yyyy")
)

Of course it does!!! Thanks Jonathon. You’re a rock star!