+ Start a Discussion
Priya AakankshaPriya Aakanksha 

How to write validation for when lead status is working then mobile or email is mandatory?

How to write validation for when lead status is working then mobile or email is mandatory?

I wrote this validation like this:
--------------------
AND((ISPICKVAL(Status ,"Working"))
OR(
ISBLANK(Email),ISBLANK( MobilePhone )
)
)
---------
But nor working , it is asking for both
 
Rushita Bavishi 1Rushita Bavishi 1

Hi Priya,

You can use this validation rule:

AND(
ISBLANK(Email),
ISBLANK(MobilePhone),
ISPICKVAL(Status,"Working")
)

Hope it will help you.

UnlockMyTV apkUnlockMyTV apk
Try this 
AND( TEXT(status) = "unqualified",
ISBLANK(TEXT(Why_Unqualified__c)) )
OR

AND
( TEXT(status) = "unqualified",
NOT(LEN(Why_Unqualified__c) > 0) )

check this :- https://cinemahdapk.me/