Conditions
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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 ( list of values to compare against)
Not One Of ( list of values to compare against)
Matches Regex ( to test the value)
Between (inclusive range of values as a , e.g. 1,5
means between 1 and 5)
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
For cells containing dates you can define checks to see if they are:
Yesterday
Today
Tomorrow
Equal To
Not Equal To
Before
After
One Of ( list of values to compare against)
Not One Of ( list of values to compare against)
Matches Regex ( to test the value)