-
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
How to show multiple accounts of Salesforce on Leaflet Map?
Hi All, Here's the step by step solution for the above question: For achieving the above scenario first we need to create two custom fields…
Understanding the Salesforce Ecosystem: A Complete Platform for Customer Success
Popularly known as the world’s number one customer relationship management (CRM) platform – Salesforce is entirely cloud-based, with standalone applications for sales, customer service, and…
Top Salesforce Lightning Components to Improve Functionality
In this techie environment, it is the necessity to be with the new generation and meet up the expectation of the business organization. Almost every…
Popular Salesforce Videos
Salesforce Business Analyst Training
In the 35th Episode of the #AskTheHulk series, Savitha Asked about how to switch to IT from Non-IT background. To this question, Shrey suggested that…
Salesforce Essentials vs Professional
In this video, Bradley Large answers some of the most common questions people have about Salesforce. He gives clear and concise answers to questions like:…
Reason to Switch the Job | Future of Salesforce Job Market | Christopher A Hopper
Here is the Glimpse of Conversation with Christopher A Hopper on the topic "Reason to Switch the Job". This is the very first episode of…