The lead sttus can't be update to Qualify when
Rate = none,
Country, FirstName and Lastname are empty,
Address or Phone number have a value.
Can someone help me ? I tried several functions and the is:
AND (
ISPICKVAL (Status, "Qualified") ,
NOT ( ISPICKVAL (Rating,"")),
NOT ( ISBLANK ( LastName ) ),
NOT ( ISBLANK ( FirstName ) ),
(OR(NOT ( ISBLANK (Email)), (NOT (ISBLANK (Phone))))
)
)
Thank you !!
PO
6 个回答
But personally I think you'd want something like this:
AND(
TEXT(Status) = "Qualified" ,
OR(
ISBLANK(TEXT(Rating)),
ISBLANK(LastName),
ISBLANK(FirstName),
ISBLANK(Country) ,
ISBLANK(Email),
ISBLANK(Phone)))
