Ah, also that special care needs to be paid to whether itās a value, or a list with a single value.
- in formulas (using
.First()
where appropriate) - in formula columns with Lookup table type (properly switching the āAllow multiple valuesā on or off)
More on that: Hereās a riddle for the community