Apply data validation to a cell or series of cells to keep data in your spreadsheets consistent.
Required Editions
| Available in: Quip desktop app, Quip iOS mobile app, and Quip on web |
From the Data menu, select Data Validation. Or, right-click to
open the cell menu, and select Data Validation.
| Select From List | Users select a cell value from a dropdown list. Enter and sort the values for the dropdown list, and choose a color to apply to the cell for each value. |
| Select From Range | Users select a cell value from a dropdown list that references a range of data in the spreadsheet. Select the data range that you want to reference from the spreadsheet. |
| Number | Users can enter only numbers in this cell. To specify a range, choose an operation and enter an argument. |
| Users can enter only email addresses in this cell. | |
| Text | Users can only enter text that matches, contains, or doesn’t contain a specified text string. To define the text string, choose an operation and enter an argument. |
| Date | Users can enter only dates. To specify a date range, choose an operation and enter an argument. |
| Attachment | Users can add only attachments to the cell. |
| URL | Users can enter only URLs in the cell. |
| Checkbox | Format the cell as a checkbox. |
| Person | Users can only @ mention people in the cell. |
- Use Dropdown Lists in Spreadsheet Cells
Create a dropdown list for a cell or series of cells to let users choose from a group of defined values when entering data.