Salesforce Administration

How to write formula for Picklist values & currency fields types in Salesforce custom objects

Kam Matharu
  • Salesforce Administration, custom formula
Example #1 = To decide the target incoice date
Field name: “Invoice_Date__c” is the day when invoice generated
“Day_Till_Due_Date__c” is a picklist (Value are like 7, 14,21,28,60 etc..)
Invoice_Date__c + Value(Text(Day_Till_Due_Date__c ))
TimeSheet calculations:
No of Hours + Overtime hours (weekend & bank holidays) + Overtime hours (weekdays)
e.g Picklist values are – 0,1,2,3,4,5,6,7,8
HourlyRate__c * (NoOfHours__c +
((Value(Text(OT_W_Bhol__c))) * 2 +
((Value(Text(OTWeekDays__c))) *1.5)))
Unknown's avatar

Published by Kam Matharu

Introducing Kam! With over 22 years of experience in the IT industry and more than 9 years specializing in the Salesforce ecosystem. I began my career in .Net technologies before transitioning to Mobile Security products and databases in London, UK. Since 2013, I've been dedicated to CRM, particularly Salesforce, while also actively engaging in knowledge sharing through various professional channels. Connect with me on my social link: linktr.ee/ksm1313live.

Leave a comment