---
schema_version: "1"
id: 5c340fa77cb09e415962a74d0772faf85975dae10c0a898bcd365354cbb58f65
title: all?
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_function_ref_all.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_all.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 08eca6ede86efda5e0e81fb6944260e4498f728cc08377a0092e5ff76ba2face
description: Checks whether every record in a data filter or datasheet in Salesforce Spiff satisfies one or more conditions. This function returns true when the condition is satisfied. This function is the opposite of the any? function.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# all?

Checks whether every record in a data filter or datasheet in Salesforce Spiff satisfies one or more conditions. This function returns `true` when the condition is satisfied. This function is the opposite of the `any?` function.

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

## Syntax

```
all?(datasheet_or_filter, condition)
```

## Arguments

  
| Argument | Required? | Description |
| --- | --- | --- |
| datasheet\_or\_filter | Required | The datasheet or filter that specifies the list of records to test. |
| condition | Optional | The condition to test. Use any expression or formula that results in `true` or `false`. To compare values, specify comparison operators or logical functions such as `AND` or `OR`. For example, to test whether the ARR field is greater than $100,000, enter `ARR > 100000`. |

## Example

Test whether all rows for the ARR field in the BigDealsSheet datasheet have a value greater than $100,000.

```
=all?(BigDealsSheet, ARR > 100000)
```

![Example of the all function in a datasheet](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/sales_performance_management/images/spiff/spiff_function_ref_all.png)

Because all the values exceed $100,000, this function returns `true`. If you change the condition to test for $50,000, this function returns `false`.

If the datasheet or filter contains no rows or records, this function returns `true`. To test whether the datasheet or filter includes at least one record first, add an `any()` function before the `all?()` function.

```
=any?(BigDealsSheet, true) AND all?(BigDealsSheet, ARR > 100000)
```