In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Data Validation Rules to Stop Bad Entries
Prompt
App and version: {{SPREADSHEET_APP}}
Columns on the entry sheet, with what each should contain: {{COLUMN_SPEC}}
Who will fill it in and how careful they are likely to be: {{USERS}}
Mistakes that have already happened: {{PAST_ERRORS}}
For each column, specify:
1. The validation rule (list, whole number, decimal range, date range, text length, or custom formula) with the exact settings or formula to enter.
2. The error alert style (stop, warning or information) and the message text, written in plain, helpful language.
3. An input prompt, if it helps.
4. A conditional formatting rule that highlights entries that pass validation but still look wrong (for example a date far in the future).
Also cover: how to build dropdown lists from a separate list sheet so they update, how to protect formula cells, and the limits of validation (pasted values bypass it, so suggest a check column). Finish with a short checklist to test the sheet by deliberately entering five bad values.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Data Validation Rules to Stop Bad Entries” is a free prompt for ChatGPT in the Productivity category, 175 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SPREADSHEET_APP}}, {{COLUMN_SPEC}}, {{USERS}}, {{PAST_ERRORS}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 5 times.
Browse all Productivity prompts, the AI prompt database or use the AI prompt finder to search every prompt.