---
schema_version: "1"
id: 7261610f5ce1d5e4ec9121bef6c630e601086c9c980dcda80d102a76fc111b55
title: Add Values to a Quota Table
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_quotas_values.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_quotas_values.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: dafa0f4141f7cda91c726bd776a126ebca524affdcd0fc3700313444b439fa99
description: After you've created a quota table and assigned users in Salesforce Spiff, enter quota values.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Add Values to a Quota Table

After you've created a quota table and assigned users in Salesforce Spiff, enter quota values.

### 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="d79848e78">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d79848e78 ">To add values to a quota table:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d79848e78 ">
              <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;">Quotas: Edit</p>
            </td>

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

This topic describes adding quotas directly to the quotas table. You can also assign a specific user to a quota in the user’s profile. For large-scale changes, use the upload functionality to add new team assignments, or update existing team assignments. See [Bulk-Uploading Users, Plan and Team Assignments, Currency Rates, and Quotas](https://help.salesforce.com/s/articleView?id=sales.spiff_bulk_upload_management.htm&release=264.0.0&type=5 "Manage large updates to your users, plans, teams, currency rates, and quotas in Salesforce Spiff by bulk-uploading records in Mass Data Management.") for more information about mass data management.

1. In Quotas, select the quota to which you want to add values.
2. In the quota table, click **Edit**.
3. Add values to the quota table with one of these methods.
    - Enter values in the table using Drag and Drop. This function performs similarly to Excel. After you’ve entered an amount into a cell, you can click the corner and drag it horizontally or vertically to copy across cells quickly.
    - Copy and Paste from a Spreadsheet. Click the download icon to export the quota table. The download preserves the order of users on the table and any entries that have been made. You can then update the table in Excel and copy and paste from the spreadsheet back into the table.
4. Save the changes.

#### See Also

- [months\_to](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_months_to.htm&release=264.0.0&type=5 "Returns the number of months between two dates or times in Salesforce Spiff. If the return value is a negative number, the second date occurred before the first date.")