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
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!