Hi
I’m trying to use this formula
IFS(
[_THISROW].[COMPANY]=LOOKUP([_THISROW].[COMPANY],“Pontos de venda”,“COMPANY”,“COMPANY”),
LOOKUP([_THISROW].[COMPANY],“Pontos de venda”,“COMPANY”,“Company_ID”),
[_THISROW].[Email da empresa]=LOOKUP([_THISROW].[Email da empresa],“Pontos de venda”,“COMPANY_PERSON_EMAIL”,“COMPANY_PERSON_EMAIL”),
LOOKUP([_THISROW].[Email da empresa],“Pontos de venda”,“COMPANY_PERSON_EMAIL”,“Company_ID”),
[_THISROW].[Email da empresa]=LOOKUP([_THISROW].[Email da empresa],“Pontos de venda”,“EMAIL_1”,“EMAIL_1”),
LOOKUP([_THISROW].[Email da empresa],“Pontos de venda”,“EMAIL_1”,“Company_ID”)
)
but only the first phase works
"[_THISROW].[COMPANY]=LOOKUP([_THISROW].[COMPANY],“Sale Points”,“COMPANY”,“COMPANY”),
LOOKUP([_THISROW].[COMPANY],“Sale Points”,“COMPANY”,“Company_ID”),
"
But when don’t find it in the first phase and move on to the second, it no longer works.
Is there something missing from the formula?
The key is [CRM_ID]
User | Count |
---|---|
43 | |
26 | |
25 | |
14 | |
11 |