-
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 Flows - What You Need to Know
Businesses strive to grow bigger and better, but the amount of complex processes becomes trickier to manage without a reliable system that can streamline multiple…
Why all Salesforce Users Should Integrate Their Systems
A common scenario with organizations using Salesforce is having a scenario where employees from different departments, are not able to access the same accurate, real-time…
Problem Solving | Salesforce Project Implementation
'I am happy to help you', I replied to a post on a Salesforce group. A group member posted a roadblock in his recent Salesforce…
Popular Salesforce Videos
Salesforce Customer 360 for B2C Solutions
Learn about Slalom's approach to creating integrated customer-focused experiences spanning B2C Commerce, Marketing Cloud, Service Cloud, Experience Cloud, and beyond. Watch this video by Salesforce…
Getting to Know Einstein Analytics
Einstein Analytics is an app used to visualize the activity occurring in your Salesforce environment. Whether you use Salesforce for Sales, Marketing, or Service, this…
Predicted Job Growth of Salesforce Business Analysts
In this video, Ben Analyst predicts the potential future growth of Salesforce. He compares the growth of Salesforce to other companies' growth rates and also…
