Help

Using lookup value in a formula has a weird behavior

Topic Labels: Automations
383 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Chadd_Dumagas
5 - Automation Enthusiast
5 - Automation Enthusiast

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}))

Solution 2
LEN({My Email To}&"")

Freaking amaaaaaaazziiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiing riiiiiiiiiiiiiiiiiiiiiiiiiiiiiiight? :clown_face:

is this the simplest solution? do you have any other solution?

WEIRD SITUATION 2
When you use
{Name} with values (Name1, Name2), << linked field, with multiple values
{My Email To} with values (Email 1, Email2) << lookup field, values shows with space and comma

{My Email To}&"" return values (Email 1Email2) << formula field without space and comma!!!

why does the lookup field value change? why can’t they just make that in-line value a literal flat string?

0 Replies 0