You are here:
Add Values to a Quota Table
After you've created a quota table and assigned users in Salesforce Spiff, enter quota values.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
| User Permissions Needed | |
|---|---|
| To add values to a quota table: | A Spiff user role with this permission turned on. Quotas: Edit |
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 for more information about mass data management.
- In Quotas, select the quota to which you want to add values.
- In the quota table, click Edit.
-
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.
- Save the changes.
See Also
Did this article solve your issue?
Let us know so we can improve!

