+ Start a Discussion
MC34MC34 

Checkbox formula field.

Hi I am looking for a checkbox formula field (contact_sync__c) that takes two picklist fields and one checkbox field into criteria. 

The checkbox should be checked if ----

Shared email field (checkbox is Unchecked) - custom Checkbox field
Contact status is "Active" (custom picklist field)
Resp.type is "SALES_SERVICE" (custom picklist field)


Thank in advance
Mit
 
Best Answer chosen by MC34
VinayVinay (Salesforce Developers) 
Try below
 
AND(Shared_email_field=false, ISPICKVAL(Contact status, 'Active'),ISPICKVAL(Resp.type, 'SALES_SERVICE') )

Hope this helps..

Thanks

All Answers

RituSharmaRituSharma
Your formula should be like below:

And(Email,ISPICKVAL(Status,"Active"),ISPICKVAL(Resp.type,"SALES_SERVICE"))

It will return true if all the 3 conditions meet.
MC34MC34
hI Ritu, not sure - 

Shared email field (checkbox is Unchecked)- does your formula ask for "unchecked" parameter? 
VinayVinay (Salesforce Developers) 
Try below
 
AND(Shared_email_field=false, ISPICKVAL(Contact status, 'Active'),ISPICKVAL(Resp.type, 'SALES_SERVICE') )

Hope this helps..

Thanks
This was selected as the best answer
MC34MC34
Vinay - worked like charm! Thank you!