# 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](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Not One Of ([CSV](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Matches Regex ([JavaScript RegExp](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions) to test the value)
* Between (inclusive range of values as a [CSV](https://en.wikipedia.org/wiki/Comma-separated_values), 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](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Not One Of ([CSV](https://en.wikipedia.org/wiki/Comma-separated_values) list of values to compare against)
* Matches Regex ([JavaScript RegExp](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Regular_Expressions) 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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://documentation.checksheet.app/concepts/conditions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.