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.
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
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
Last modified 2mo ago