function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bhagyashri Jadhav 61Bhagyashri 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
Best Answer chosen by Bhagyashri Jadhav 61
PriyaPriya (Salesforce Developers) 
Hi Bhagyashri ,

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

PriyaPriya (Salesforce Developers) 
Hi Bhagyashri ,

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
This was selected as the best answer
Bhagyashri Jadhav 61Bhagyashri Jadhav 61
Thank you, Priya the requirements is changed by my boss. Now we have created the multi-picklist with all the values like phone, email, and name. once we select the staus as junk or unqualified this multiscale picklist cant is blanck.