Stop Status Typos in Google Sheets With One Dropdown

Before you start

• A Google account with access to Google Sheets on a computer.
• A new Sheet into which you import status-tracker-practice.csv.
• Permission to edit that Sheet. The names and tasks are invented for this tutorial.

Swipe or scroll sideways to see every table column →

Add the rule

1. Check that the header is on row 1 and the five tasks occupy rows 2–6. Select D2:D6; do not include the Status header.
2. Choose Data → Data validation → Add rule. Google's current help also offers Insert → Dropdown. In the rule panel, confirm that the selected range is D2:D6.
3. Under Criteria, choose Dropdown. Add three separate choices, spelled exactly Queued, In progress, and Done. Their colors are optional.
4. Open Advanced options and make sure invalid data is rejected. Google says an entry that is not in the list is rejected by default; Show a warning permits other values. Save the rule with Done.

These menu labels match Google's dropdown instructions checked 9 October 2026. Google may move controls, so use the equivalent options you see in the current interface.

Test it before trusting it

5. Click D2 and try to enter In progres (one s missing). With rejection active, Sheets should refuse the entry; D2 should remain Queued. If the typo is accepted, inspect the rule's target range and switch Show a warning to Reject input.
6. Choose Done from D2's dropdown. Your five rows should now contain 3 Done, 2 In progress, 0 Queued, and 0 In progres. Compare with the answer checks.

Common mistakes

• The dropdown looks right but a typo is accepted. The rule may use warning mode or miss the target cell. Reopen Data validation and inspect both.
• A new task row has no dropdown. This exercise targets only D2:D6; extend the range or copy the rule into new rows.
• The CSV export lost the dropdown. Keep the Google Sheet as your editable master. CSV preserves the visible values, not the rule.
• Existing statuses differ slightly. Standardize them deliberately before counting. A dropdown does not prove that an older value was semantically correct.

FAQ

Can the choices come from cells instead? Yes. Choose Dropdown from a range and point the rule at cells holding the approved values. The three fixed choices here keep the first exercise short.

Can users select more than one option? Google's help supports multiple selections only for a chip-format dropdown, and mobile selection has limitations. This tracker intentionally requires exactly one status per task.

Does color enforce the allowed values? No. The invalid-data option decides whether unmatched text is rejected.

Source and visual note

Primary reference: Google Docs Editors Help — Create an in-cell dropdown list. The companion video uses English illustrative diagrams, not application screen recordings. A separate fictional practice test confirmed that In progres was rejected and a valid Done choice produced three Done and two In progress statuses. That test used a localized account; the English control names in this guide follow Google Help. Repeat the action and count check in your own account before relying on the tracker.