You need to sign in to do that
Don't have an account?
Bhagyashri Jadhav 61
I am creating a validation rule. requirement is when we select status=junk any below field cant be blank
AND(ISPICKVAL( Status ,"Junk"),
OR(ISBLANK( Phone ),
OR(ISBLANK ( Email ),
OR(ISBLANK( Description ),
OR(ISBLANK( Company ))
This is not working
OR(ISBLANK( Phone ),
OR(ISBLANK ( Email ),
OR(ISBLANK( Description ),
OR(ISBLANK( Company ))
This is not working
Can you please try as below
AND(ISPICKVAL( Status ,"Junk"),
OR(ISBLANK( Phone ),
ISBLANK( Email ),
ISBLANK(Description),
ISBLANK(Company)))
Hope this is helpful!!Please mark this as best answer
Regards,
Priya Ranjan
All Answers
Can you please try as below
AND(ISPICKVAL( Status ,"Junk"),
OR(ISBLANK( Phone ),
ISBLANK( Email ),
ISBLANK(Description),
ISBLANK(Company)))
Hope this is helpful!!Please mark this as best answer
Regards,
Priya Ranjan