Values

The value(s) that your check condition is evaluated against can be one of three types as listed below.

It's important to note that when evaluating your checks we use the raw value from the spreadsheet, without any formatting applied. For example if you have a cell with a price in that you have formatted as a currency when entering the value you should not include this formatting, just the raw numeric value.

Text

Any piece of text.

• Example: banana

• Example: multiple words

Number

Any integer or decimal.

• Example: 5

• Example: 9.99

Range

A reference to a a single cell or range of cells using A1 notation that is prefixed with an equals sign.

• Example: =A1

• Example: =C1:C10