-
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
Expertise and Support: The Key Benefits of Choosing a Salesforce Partner Company - InfoDrive Solutions
Salesforce is a powerful platform that can help businesses streamline their operations, increase productivity, and improve customer relationships. However, implementing and managing Salesforce can be…
How Salesforce Training And Certifications Help with Better Career Opportunities for IT Professionals
About: If you're looking for it, then BismilSoft gives you the fine Salesforce education direction in Noida with stay task and certification. The Salesforce education…
Salesforce Product : Health Cloud
On huge focus upon the healthcare industry the world's #1 CRM Salesforce has introduced something best product which is termed as Health Cloud. A product…
Popular Salesforce Videos
Introduction to SFDX Deploy Tool for Windows | Salesforce Integration Tutorial Series
In this tutorial, we're going to learn about SFDX Deploy Tool for Windows. SFDX Deploy Tool helps you to deploy metadata from one Salesforce org…
Salesforce Heroku Integration | Heroku Connect
Heroku is a cloud platform that lets deploy, run and manage applications and websites. It is part of Salesforce Platform. This video will explain about…
How to Edit List View Filters in Accounts and Contacts Tabs | Salesforce
Watch this video to learn How to Edit List View Filters in ‘Accounts’ and ‘Contacts’ Tabs. If you find anything confusing or have any questions,…
Popular Salesforce Infographics
State of Appexchange Salesforce Apps Market 2025
The Salesforce AppExchange continues to expand, providing businesses with innovative tools to enhance their Salesforce experience. With thousands of solutions available, the marketplace has become…
What You’ll Get with the Salesforce MVP Infographic
We scanned the profiles of Salesforce MVPs, both past and present, searched high, low, near and far to provide insights into what it specifically takes…
Streamlining the Sales Process with Salesforce CPQ
Implementing Salesforce CPQ offers numerous business advantages, such as automating tasks, including sales quotations and price determination. Businesses that use Salesforce CPQ can expect increased…
