-
Formula Syntax for Percentages dependent on picklist values
Hello! I need some assistance with a formula I am trying to create.
Here are the fields and variables I am working with:
Picklist 1 = List of Names
Picklist 2 = List of Names
Percentage 1 = %
Percentage 2 = %Basically here is what I would like the formula to do for the field Percentage 2...
If the value for "Picklist 1" = "Picklist 2", then "Percentage 2" should receive the same value that was input for "Percentage 1". If not, the value for "Percentage 2" should be set to 0.00%.Here is what I have and the error I am getting:
IF("Picklist_1__c" = "Picklist_2__c", "Percentage_1__c", 0.00)
Error: Incorrect parameter type for function 'IF()'. Expected Text, received Number -
0 Replies
Log In to reply.
Popular Salesforce Blogs
Why Businesses Hire Salesforce Service Cloud Certified Consultants in 2026
Customer service has become a key competitive differentiator across industries. Today's customers expect fast resolutions, personalized support, and consistent experiences across multiple communication channels. Meeting…
A Quick Guide to Salesforce AppExchange
What is AppExchange? AppExchange is Salesforce’s online marketplace from where you can download and install more than 4.000 solutions for your organization. The wide variety…
Salesforce Consulting Services: Roles & Responsibilities
Introduction A leading business expert has correctly said- “Salesforce is a wonderful skill which if properly harnessed; can open the doors of fortune at your…
Popular Salesforce Videos
Use Salesforce CMS to Manage and Publish Content for Experience Cloud Sites
Learn how Salesforce CMS helps you create, manage, and publish your content in Experience Cloud. With Salesforce CMS, you can also customize content for specific…
10 Example Future Method with Test Class | Asynchronous Apex | Salesforce Development Training Video
Salesforce uses a queue-based framework to handle asynchronous processes from such sources as future methods and batch Apex. This queue is used to balance request workload across…
Salesforce Online Training Videos For Beginners | Campaign Management
Learn all about the Salesforce campaign management in this video. Watch and learn. If you have any doubts or questions, please let us know in…
Popular Salesforce Infographics
What is a CRM System?
Customer relationship management (CRM) is a technology for managing all your company's relationships and interactions with customers and potential customers. The goal is simple: Improve…
How Building Apps on Salesforce Has Tremendous ROI
The pressure that businesses today are under to reduce costs, improve agility, and deliver better results is no joke. Couple that with rapidly evolving technology…
