---
schema_version: "1"
id: d45fbf952b4f685000ebc40ddd0326a2ed98a83c3e0e53295a67fb49b9d14ad7
title: Sheets and Tables in Salesforce Spiff Designer
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_designer_sheets.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_designer_sheets.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 53c1178c9798fb7ec61d0b3882e0c11237e35ae846cd7f873987302399301c06
description: Handle large amounts of data from multiple sources and create and filter calculations by using worksheets, datasheets, and tables in Salesforce Spiff Designer.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Sheets and Tables in Salesforce Spiff Designer

Handle large amounts of data from multiple sources and create and filter calculations by using worksheets, datasheets, and tables in Salesforce Spiff Designer.

## Worksheets

Worksheets provide the functionality to create calculations that produce a single output, unlike a datasheet calculation that's applied to rows of filtered data. Worksheets are more structured than Microsoft Excel spreadsheets, as fields have version history and calculations are contextual to the time period, plan, and user selected in Designer.

Worksheet fields have these characteristics.

- Show a single value that applies to a period, rep, and plan.
- Save memory because you can reuse them if the calculation doesn't equate to a different value per opportunity, deal, or line item.
- Support quotas, plan assignments, base rates, and aggregated amounts.

## Datasheets

A datasheet is a set of filtered records that originate from your data sources. In a datasheet, create and apply calculations to this data. For example, a filter called ClosedInPeriod returns only opportunities closed by the specified rep in the specified period. When you apply that filter to a datasheet, you can add or create calculations that apply only to the defined set of data.

Datasheet fields have these characteristics.

- Show a different value on each row from a data filter. Create a datasheet field only if the value can change from row to row.
- Support ARR and attainment percentage calculations.

![Tip](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_tip.png)

Tip For functions that return a list and not a single value, hover over the cell for a window that shows the number of returned items, the first few items in the list, and an option to copy the list to the clipboard.

## Tables

Range tables and lookup tables are common features of many incentive compensation or commission plans. Range tables are most commonly used with accelerators, and lookup tables are frequently used for applying different rates based on product categories or SKUs.

Quota tables outline sales targets within a specific period.

- **[Considerations for Datasheets in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_datasheets_considerations.htm&release=264.0.0&type=5)**  
    Datasheets let you create and apply calculations to a filtered set of records from your data sources.
- **[Create a Datasheet in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_datasheets_create.htm&release=264.0.0&type=5)**  
    Analyze your data in new ways when you create and apply calculations to a specific set of filtered data.
- **[Considerations for Worksheets and Worksheet Calculations](https://help.salesforce.com/s/articleView?id=sales.spiff_worksheets_and_calculations_considerations.htm&release=264.0.0&type=5)**  
    Worksheets provide the functionality to create calculations that produce a single output. Worksheet calculations are flexible and can be used in data filters, other worksheet fields, and in datasheet fields tied to objects on unrelated plans.
- **[Create a Worksheet in Salesforce Spiff and Add a Calculation](https://help.salesforce.com/s/articleView?id=sales.spiff_worksheets_and_calculations_create_add.htm&release=264.0.0&type=5)**  
    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.

#### See Also

- [Considerations for Datasheets in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_datasheets_considerations.htm&release=264.0.0&type=5 "Datasheets let you create and apply calculations to a filtered set of records from your data sources.")
- [Considerations for Worksheets and Worksheet Calculations](https://help.salesforce.com/s/articleView?id=sales.spiff_worksheets_and_calculations_considerations.htm&release=264.0.0&type=5 "Worksheets provide the functionality to create calculations that produce a single output. Worksheet calculations are flexible and can be used in data filters, other worksheet fields, and in datasheet fields tied to objects on unrelated plans.")