Formula Fields (2)


Salesforce Formula For Calculating Case Age In Hours Excluding Weekends

This is a modification of the Salesforce formula for finding the number of business hours between two dates. Here is the Salesforce formula: ROUND( 8 * ( ( 5 * FLOOR( ( DATEVALUE( date/time_1 ) – DATE( 1900, 1, 8) ) / 7) + MIN(5, MOD( DATEVALUE( date/time_1 ) – DATE( 1900, 1, 8), 7) […]




Adding Custom Color Flag Fields in Salesforce

Salesforce no longer allows you to create custom fields with custom background colors. However, you can add images to custom fields. Let’s say you wanted to create a custom field to identify case age in business hours. For this example, we’ll identify a case opened within 24 hours with a green flag, a case opened […]