Coding · Spreadsheets

Add Dropdown Lists and Input Checks to a Sheet

Stop typos in shared spreadsheets by adding dropdown menus and rules for what people can type.

Prompt Code output

Several people fill in the same spreadsheet in [SPREADSHEET_APP] and they keep typing things differently. The columns I want to control are: [COLUMNS_TO_CONTROL]. The allowed choices or rules for each are: [ALLOWED_VALUES]. Walk me through adding dropdown lists and simple input rules so people can only enter valid values. Give me the exact menu path for each step and tell me which cells to select first. If a rule needs a custom formula, write it for me and explain it in plain words. Also show me how to add a short help message that appears when someone clicks the cell, and how to colour cells that break a rule.

Fill in the brackets

[SPREADSHEET_APP]
Excel or Google Sheets
[COLUMNS_TO_CONTROL]
e.g. column C Status, column E Due date, column F Amount
[ALLOWED_VALUES]
e.g. Status: To do / Doing / Done; Due date must be in the future; Amount above 0

How to use

  1. Copy the prompt.
  2. Replace the text inside [BRACKETS] with your own details.
  3. Paste it into ChatGPT or another AI assistant.
  4. Read the result and ask for changes if needed.

Tip: Put your list of choices on a separate tab so you can change them later without redoing the dropdowns.