Hi I am trying to have a list of Pallets appear in a drop down list, with the Pallet # shown in the top line then underneath the description of the pallet. Have being trying to get the line break in the label column which is a Virtual column with a Long Text Type with the attached app formula
CONCATENATE("Pallet # - “,[Pallet #],”
",SELECT(Contents of Pallet[Product Label],[Pallet #]=[_THISROW].[Pallet #]))
Would like to have the enum list show this as
Pallet # -1
Peach - 5kg Tray - Medium
Thanks