---
schema_version: "1"
id: 1a035b5d9f39275236c572eba199a80f079c484521a9b3b498763f4c38fb1ae4
title: Create a Worksheet in Salesforce Spiff and Add a Calculation
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_worksheets_and_calculations_create_add.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_worksheets_and_calculations_create_add.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 0c0bd194e86f644996f5af708843231ae7035c320d33e44b187a4718977a43b9
description: Define and manage sales compensation plans and determine the payouts based on those plans. Worksheets and calculations ensure that sales compensation is accurately and fairly distributed, aligning with the organization's goals and motivating the sales team.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Create a Worksheet in Salesforce Spiff and Add a Calculation

Define and manage sales compensation plans and determine the payouts based on those plans. Worksheets and calculations ensure that sales compensation is accurately and fairly distributed, aligning with the organization's goals and motivating the sales team.

### 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 (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</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="d62328e77">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d62328e77 ">To create a worksheet:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d62328e77 ">
              <p>A Spiff <a href="https://help.salesforce.com/s/articleView?id=sales.spiff_users_roles_and_permissions.htm&amp;release=264.0.0&amp;type=5" title="Give users the appropriate level of access so they can be successful in Salesforce Spiff, and enforce the principle of least privilege. Assign a default role to each user, or create custom roles with access to specific Spiff functionality.">user role</a> with this permission turned on.</p>
              <p style="margin-bottom:0;">Designer Configuration: Manage</p>
            </td>

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

1. In Designer under Plans, click the three dots next to the search bar or next to a worksheet or folder.
2. Click **New Worksheet**.
3. Rename the worksheet.
4. Double-click a cell in a worksheet and type in your syntax. Start formulas with \= unless you’re creating a label or constant value.
5. To save your formula, click the blue check mark.