I have read the documentation and I am aware that picklist values need to use ISPICKVAL in the formula
I want this formula to show that If the status is 'A' or 'B' it will show the days (in numbers) for the first date if it isn't any of those statuses it will show the second.
IF(ISPICKVAL(Status, "A") || ISPICKVAL(Status, "B")), Date1__c - TODAY(), Date2__c- TODAY()How do I let the system choose whether to show the result of the first or second working out?
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask Salesforce Expert
Answered on Apr 18, 2023
You prematurely closed the IF (marked here with "****" around it):
IF(ISPICKVAL(Status, "A") || ISPICKVAL(Status, "B")****)****,
Date1__c - TODAY(),
Date2__c- TODAY()
Try:
IF(ISPICKVAL(Status, "A") || ISPICKVAL(Status, "B"),
Date1__c,
Date2__c) - TODAY()This includes DerekF's recommended optimization of pulling out subtracting today.
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step Salesforce guides from industry experts
Common Salesforce interview questions, answered
Guides, tips and career advice on Salesforce from JanBask experts.
Salesforce Cost for Salesforce Certification: Exam Fees by Type, Retakes & Hidden Costs
Salesforce certification exam fees run $75 to $4,500, and most cost $200. See cost by role, retakes, taxes, discounts, and…
Salesforce Salesforce Admin Certification Cost 2026: Exam Fees, Retake & Other Expenses
Learn the Salesforce Admin certification cost in 2026, including the exam fee, retake cost, taxes, discounts, preparation…
Salesforce How to Get Into Salesforce With No Experience
Wondering if you can get a Salesforce job with no experience? Learn how to pick a career path, build real skills, and land your…
Salesforce How to Become a Salesforce Developer Without Experience
No coding background? Learn how to become a Salesforce Developer step by step - skills to build, projects to create, and how to…