---
schema_version: "1"
id: 877ca3768434c825441fee23d8fabcda64d6ad353f69e1573c07fe98d286df86
title: Find Examples of Advanced Formulas
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/useful_advanced_formulas.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8aab67328f2d13bef2fd067bd07f8afa0ad3b8398b2b9319a901b3a27c4f375d
description: Review sample formulas for sales, service, financial, employee-services, and integration scenarios. Examples cover commissions and discounts, cross-object references, date and time calculations, image links, data completeness, and more. Adapt the formulas to your fields and business requirements.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Find Examples of Advanced Formulas

Review sample formulas for sales, service, financial, employee-services, and integration scenarios. Examples cover commissions and discounts, cross-object references, date and time calculations, image links, data completeness, and more. Adapt the formulas to your fields and business requirements.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Essentials</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d95735e80">User Permissions Needed</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d95735e80 ">To view formula field details:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d95735e80 ">View Setup and Configuration</td>

        </tr>
        <tr class="">
          <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d95735e80 ">To create, change, or delete formula fields:</td>

          <td class="slds-cell-wrap" style="vertical-align:top;" headers="d95735e80 ">Customize Application</td>

        </tr>
      </tbody>
    </table>

Browse these categories to find relevant formula examples. For details about the operators and functions used in these formulas, see [Formula Operators and Functions by Context](https://help.salesforce.com/s/articleView?id=platform.customize_functions.htm&release=264.0.0&type=5 "Use these operators and functions when building formulas. All functions are available everywhere that you can include a formula, such as formula fields, validation rules, approval processes, and workflow rules, unless otherwise specified.").

- **[Sample Account Management Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_acct_mgmt.htm&release=264.0.0&type=5)**  
    Rate an account, assign sales regions based on billing state, and track the age of active contracts.
- **[Sample Account Media Service Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_acct_media_svc.htm&release=264.0.0&type=5)**  
    Create formula links to web and news services, such as Bloomberg, Google, or Yahoo, based on account names or financial ticker symbols.
- **[Sample Case Management Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_case_mgmt.htm&release=264.0.0&type=5)**  
    Create autodial links, categorize cases by age, measure data completeness, and suggest agent prompts or offers based on purchase and support information.
- **[Sample Commission Calculations Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_commission.htm&release=264.0.0&type=5)**  
    Calculate commissions, assign rates by deal size, identify commissions that meet a threshold, and return the highest asset commission.
- **[Sample Contact Management Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_contact_mgmt.htm&release=264.0.0&type=5)**  
    Display account details on contact pages, create profile and website links, assign contact identifiers and priorities, and format addresses and phone numbers.
- **[Sample Data Categorization Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_data.htm&release=264.0.0&type=5)**  
    Categorize deals and assets by size and classify products by a keyword in a custom text field.
- **[Sample Date Formulas](https://help.salesforce.com/s/articleView?id=platform.formula_examples_dates.htm&release=264.0.0&type=5)**  
    Use Date, Date/Time, and Date formulas for many common business needs. For example, extract and format parts of a date or time, such as quarter, week, weekday, month name, or the hour, minute, and second. Calculate durations in days, business days, or business hours. Project future and relative dates, and handle issues such as leap years, the last day of the month, and time zone conversions.
- **[Sample Discounting Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_discounting.htm&release=264.0.0&type=5)**  
    Identify discounted opportunities and calculate discount-adjusted amounts. Examples use custom currency amounts, percentages, rounding, and approval status.
- **[Sample Employee Services Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_employee_svcs.htm&release=264.0.0&type=5)**  
    Calculate bonuses, 401(k) matching, weekly hours worked, and regular and overtime pay.
- **[Sample Expense Tracking Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_expense_tracking.htm&release=264.0.0&type=5)**  
    Create identifiers from trip and expense information and calculate mileage reimbursement at a set rate per mile.
- **[Sample Financial Calculations Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_financial.htm&release=264.0.0&type=5)**  
    Calculate compound interest, consultant costs, gross margin, and contract payments. Other examples supply missing payment due dates and identify overdue unpaid payments.
- **[Sample Image Link Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_image_links.htm&release=264.0.0&type=5)**  
    Visualize case priority, case age, project status, ratings, and scores with images such as flags, colored indicators, star ratings, and proportional bars.
- **[Sample Integration Link Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_integration.htm&release=264.0.0&type=5)**  
    Create links that connect records to external systems for API integrations, carrier shipment tracking (FedEx, UPS, or DHL), and Skype auto-dialing. Review session-context restrictions and picklist-driven links.
- **[Sample Lead Management Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_lead_mgmt.htm&release=264.0.0&type=5)**  
    Track how long leads have been open, measure lead data completeness, convert lead numbers for calculations, and distribute leads or cases across queues.
- **[Sample Metric Conversion Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_metrics.htm&release=264.0.0&type=5)**  
    Convert temperatures from Celsius to Fahrenheit and distances from miles to kilometers.
- **[Sample Opportunity Management Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_oppty_mgmt.htm&release=264.0.0&type=5)**  
    Calculate opportunity revenue, costs, pricing, commissions, shipping, and contract value. Other examples categorize opportunities, measure data completeness, format revenue, and link to stage-specific sales documents.
- **[Sample Pricing Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_pricing.htm&release=264.0.0&type=5)**  
    Calculate a total amount from unit price and quantity, and derive a per-user price from total license revenue.
- **[Sample Scoring Calculations Formulas](https://help.salesforce.com/s/articleView?id=platform.useful_advanced_formulas_scoring.htm&release=264.0.0&type=5)**  
    Score leads by source or rating, and rank customers based on survey results.

#### See Also

- [Formulas: How Do I ... ?](https://help.salesforce.com/s/articleView?id=platform.how_do_i.htm&release=264.0.0&type=5 "A collection of topics around formulas, including common math calculation, text functions, and more.")
- [Tips for Building Formulas](https://help.salesforce.com/s/articleView?id=platform.tips_on_building_formulas.htm&release=264.0.0&type=5 "Extend your Salesforce data with powerful formula logic. Access a collection of tips for using specific data types in your formulas, including dates, numbers, text, picklists, and record types.")