This works fine on a new selection, but the lookup field is blank on existing records. I tried substituting several other things, like “ThisItem.fieldname”, but get an error that the formula uses scope, which is not supported.
This article got me closer than anything else… trying to get the last hurdle.
]]>