-
multiselect picklist and formula field
I have a multiselect picklist on my User Record called CountryAccess. User can select multiple countries in this field like: TH, BR. I also have another custom field called Country on my Account object which is a picklist field with all the countries.
Now what I want is to create another formula field to check if the values from the Country contain the value from the CountryAccessand if yes, return TRUE otherwise FALSE.
Let's say for example a user X has 2 values TH and BR on CountryAccess field. Now if I go to an account and the country is either TH or BR than display TRUE otherwise false.
Any ideas please? I manage to create a formula field but based on a picklist, with one value not multiselect.
-
1 Reply
-
Hi Prachi,
use these formula:-
IF(ISPICKVAL(SVMXC__Country__c ,'UK') && INCLUDES( $User.TestMultiSelectCountry__c ,"UK"),true, IF(ISPICKVAL(SVMXC__Country__c ,'BR') && INCLUDES( $User.TestMultiSelectCountry__c ,"BR"),true, IF(ISPICKVAL(SVMXC__Country__c ,'SA') && INCLUDES( $User.TestMultiSelectCountry__c ,"SA"),true, IF(ISPICKVAL(SVMXC__Country__c ,'TH') && INCLUDES( $User.TestMultiSelectCountry__c ,"TH"),true, IF(ISPICKVAL(SVMXC__Country__c ,'US') && INCLUDES( $User.TestMultiSelectCountry__c ,"US"),True,False)))))
Log In to reply.
Popular Salesforce Blogs
Salesforce Security Model - Explained
Salesforce Security Model Salesforce Security Model Classification. Security in Salesforce is broadly classified in two sorts. They are System Level Security. Application Level Security. System…
How Can Small Businesses Grow Faster With Salesforce Essentials?
Small businesses often face unique challenges on their path to growth. Efficient customer relationship management (CRM), streamlined processes, and data-driven decision-making are critical to overcoming…
All You Need to Know About Salesforce Experience Cloud
In April 2021, Salesforce decided to change its Community Cloud for a more modern service. The need to move over to the digital world has…
Popular Salesforce Videos
Difference between Workflow Rules and Process Builder in Salesforce
This video explains the difference between workflow rules and process builder. It is divided into four parts : 1. When to use Workflow 2. When…
4 Myths About Salesforce
Salesforce is a platform that helps businesses track the journey their customers take. It can help you effectively track and monitor your marketing and sales…
Create Custom App in Salesforce | Salesforce Training
Following Pointers are included in this video: 00:00:00 Agenda 00:00:36 What is Cloud Computing? 00:03:12 What is Salesforce? 00:05:21 Benefits of Cloud computing & Salesforce…
