Conditions

You can create checks on your spreadsheet data based on a variety of conditions. The conditions you can use depends upon the type of data that you are checking.

Numbers

For cells containing numbers you can define checks to see if they are:

• Valid Number

• Not Valid Number

• Empty

• Not Empty

• Equal To

• Not Equal To

• Greater Than

• Greater Than Or Equal To

• Less Than

• Less Than Or Equal To

• One Of (CSV list of values to compare against)

• Not One Of (CSV list of values to compare against)

• Matches Regex (JavaScript RegExp to test the value)

• Between (inclusive range of values as a CSV, e.g. 1,5 means between 1 and 5)

Text

For cells containing text you can define checks to see if they are:

• Empty

• Not Empty

• Equal To

• Not Equal To

• Starts With

• Ends With

• Contains

• Does Not Contain

• One Of (CSV list of values to compare against)

• Not One Of (CSV list of values to compare against)

• Matches Regex (JavaScript RegExp to test the value)

Dates

For cells containing dates you can define checks to see if they are:

• Yesterday

• Today

• Tomorrow

• Equal To

• Not Equal To

• Before

• After