How to List Referenced entries using an Alternative Label?

Hello All,

  • I have Table1, with [IDNum] as a key, [Label1] as the ticked label column, and [Label2] as an alternative label to be used in specific cases.
  • In another Table2, the column [EntriesFromTable1] of type Ref, has the formula =Table1[IDNum] in suggested values and it works fine by listing all entries with the labels in Table1[Label1] (the ticked Label)
  • In a Third Table3, i want to do the same as in the previous, but i want the produced list to be labeled based on Table1[Label2]

Is there a way to achieve that?

There is no built-in means to display an alternate label.

1 Like