I am just baffled about using the value of the lookup field cannot be directly used in a formula
WEIRD SITUATION 1
When you use
{My Email To} << lookup field, with single value
LEN({My Email To}) return #ERROR
Solution 1
LEN(CONCATENATE({My Email To}...