Values
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
Any piece of text.
Example: banana
Example: multiple words
Any integer or decimal.
Example: 5
Example: 9.99
A reference to a a single cell or range of cells using that is prefixed with an equals sign.
Example: =A1
Example: =C1:C10