You need to sign in to do that
Don't have an account?
Priya 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
I wrote this validation like this:
--------------------
AND((ISPICKVAL(Status ,"Working"))
OR(
ISBLANK(Email),ISBLANK( MobilePhone )
)
)
---------
But nor working , it is asking for both
Hi Priya,
You can use this validation rule:
AND(
ISBLANK(Email),
ISBLANK(MobilePhone),
ISPICKVAL(Status,"Working")
)
Hope it will help you.
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/