---
schema_version: "1"
id: cb5c2f6e84ec0be47488f0dd5fae42957a00e43971afd01f89b74bbff290e962
title: Referencing Items 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_color.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_designer_color.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ddd0e98c264f75c285a7dfbb0d679f6b0f241c01862c4933e92f9555cd2bc25f
description: When you work with formulas and syntax in Salesforce Spiff Designer, you can reference calculations on different sheets, objects, and tables. Color coding helps identify components.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Referencing Items in Salesforce Spiff Designer

When you work with formulas and syntax in Salesforce Spiff Designer, you can reference calculations on different sheets, objects, and tables. Color coding helps identify components.

### 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>

## Worksheet Syntax

In a worksheet, use this syntax for referencing calculations.

  
| Item to Reference | Syntax | Example |
| --- | --- | --- |
| Calculation on the same worksheet | calculation\_name | `TotalARR` |
| Calculation on another worksheet | worksheet\_name!calculation\_name | `WorksheetB!TotalARR` |
| Calculation on a datasheet | datasheet\_name!calculation\_name | `DatasheetA!TotalARR` |
| Calculation on an object | Not supported |   |

## Datasheet Syntax

In a datasheet, use this syntax for referencing calculations.

  
| Item to Reference | Syntax | Example |
| --- | --- | --- |
| Calculation on the same datasheet | calculation\_name | `ARR` |
| Calculation on another datasheet | datasheet\_name!calculation\_name | `DatasheetB!ARR` |
| Calculation on a worksheet | worksheet\_name!calculation\_name | `WorksheetA!TotalARR` |
| Calculation on an object | calculation\_name or relationship\_name | `ARR` or `AccountToDealsId` |

## Object Syntax

On an object, use this syntax for referencing calculations.

  
| Item to Reference | Syntax | Example |
| --- | --- | --- |
| Calculation on an object | calculation\_name or relationship\_name | `ARR` or `AccountToDealsId` |
| Calculation on a datasheet | datasheet\_name!calculation\_name | `DatasheetB!ARR` |
| Calculation on a worksheet | worksheet\_name!calculation\_name | `WorksheetA!TotalARR` |

## Range Table or Lookup Table Syntax

In a range table or lookup table, use this syntax for referencing calculations.

  
| Item to Reference | Syntax | Example |
| --- | --- | --- |
| Calculation in a table | calculation\_name | `ARR` |
| Calculation on a datasheet | datasheet\_name!calculation\_name | `DatasheetB!ARR` |
| Calculation on a worksheet | worksheet\_name!calculation\_name | `WorksheetA!TotalARR` |

## Syntax Color

When you work with formulas and other syntax in Salesforce Spiff Designer, color coding helps identify components.

 
| Color | Description |
| --- | --- |
| Black | Operator |
| Gray | Range or lookup table |
| Orange | Function |
| Green | Data filter, text value, or integer value |
| Blue | Relationship, connector, worksheet calculation, or system field |

Clicking the name of a function opens the Function Library tab in the right panel with more details about the function.

#### See Also

- [Right Panel in Designer UI](https://help.salesforce.com/s/articleView?id=sales.spiff_designer_right_panel.htm&release=264.0.0&type=5 "When you work in worksheets, datasheets, lookup tables, or range tables in the Plans tab in Salesforce Spiff Designer, the right panel shows important information related to the rule or calculation you’re currently working on.")