> For the complete documentation index, see [llms.txt](https://docs.quadratichq.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.quadratichq.com/spreadsheet/data-validation.md).
# Data validation
Use data validation to build no-code logic into your spreadsheets.
## Getting started
To get started with **Data validation**, right click a cell and use the expand menu. Select **Data validation**.
**Data validation** can also be found from the command palette (ctrl/cmd+p).
{% hint style="info" %}
Results from data validations can be read by programming languages like Python, JavaScript, and Formulas in Quadratic. Combine code with no-code data validations to build unlimited logic and applications for your team.
{% endhint %}
Right click --> "..." --> Data validation
## Dropdowns
You can create dropdowns from statically entered list or by reading from existing data in the sheet. In the following example the data in our dropdown is from column 3.
You can also search inside of dropdowns to filter for the criteria you're looking for.
## Checkboxes
Checkboxes resolve to TRUE or FALSE and can be read by programming languages. Note the following checkbox which is read into Python; if TRUE the code runs to calculate top 5 by set criteria, if FALSE the code doesn't run. You can use these checkboxes for all sorts of logic.
## Insert message
You can insert messages to cells using the message validation. In this example we describe where the data for this validation is coming from in a static message that displays each time the cell is clicked.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation by asking a question.
Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:
```
GET https://docs.quadratichq.com/spreadsheet/data-validation.md?ask=&goal=
```
`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.
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.
