What are chips in Google Sheets?
Chips are visual tokens in a cell that represent a chosen value from a list or a person from your organization. Dropdown chips show colored pills for categories and statuses. People chips link to Google contacts for assignees and reviewers. They keep typed data consistent while looking clearer than plain text.
When to use it
Use chips when a column needs fixed options with color cues: priority, team, content type, or owner on a shared tracker your non-technical editors update daily.
When to skip it
Skip chips when values must match exact export codes for an API, or when you need free-form tags that change every week. Plain text or hidden code columns may be safer.
How it works
-
1
Select cells, open Data > Data validation, and choose Dropdown chip list or Dropdown from a range with chip display enabled.
-
2
Define options on a Settings tab or type a short inline list; assign colors per option when the UI allows.
-
3
For people chips, pick People from the validation or insert type so editors choose from Workspace directory results.
-
4
Formulas can read chip values as ordinary text for FILTER, COUNTIF, and QUERY.
-
5
Sort and filter on chip columns like any other field; filter views can isolate one color group quickly.
-
6
Update the source list on Settings when you add a new stage instead of editing every row by hand.
Examples in Google Sheets
Priority column
High, Medium, and Low appear as red, yellow, and green chips. COUNTIF on Priority feeds a dashboard tile for open High items.
Owner people chip
Each row gets an assignee chip so @mentions and email notifications integrate with Workspace habits on project sheets.
Category plus subcategory
Parent category chip in column C drives a FILTERed validation list for subcategory chips in column D.
Better Sheets resources
Common mistakes
-
Renaming a chip label without updating formulas that still search for the old text string.
-
Mixing chips and free text in one column during a messy import cleanup.
-
Deleting the Settings list row that defines a chip color, which removes the option everywhere.
-
Expecting VLOOKUP to match chip display text when a hidden id column should hold the key instead.
-
Overloading one chip column with twenty options so colors become meaningless noise.
Frequently asked questions
- Chip vs regular dropdown?
- Chips show colored pills in the cell. Plain dropdowns show text in the cell editor with less visual pop.
- Can formulas read chip values?
- Yes. The stored value is text (or email for people chips) usable in standard functions.
- People chips without Workspace?
- People chips work best in Google Workspace orgs. Personal Gmail files may have limited directory search.
- Copy chip validation to new rows?
- Paste validation or drag-fill the column so new rows inherit the same chip list rules.
- Chips and pivot tables?
- Pivot tables group on chip text like any category column. Keep spelling consistent for clean buckets.
- Change chip color?
- Edit the validation rule or source list styling depending on whether the list is inline or range-based.
- Chips in Google Forms?
- Forms has its own choice questions. Map responses to chip columns on the linked sheet with validation after submit.
- Filter by chip color?
- Use filter views on the column value or conditional formatting if you need color-based QA beyond the chip itself.
Related Tutorials
Watch how Chip works
Naughty or Nice? - Google Sheets' New Dropdown Chips
Frustrated With Sheets New Dropdown Pills?
Google Sheets Interface Changes
Created a GPT function in Sheets
Headline Generator: Add Dropdowns
Related blog posts
Guides that explain Chip in more depth.
Google Sheets Introduces New Dropdown Chips Feature in 2022
Google Sheets introduced dropdown chips, a new feature that allows users to create and customize dropdown menus in their sheets. In this article, we will explain how to use dropdown chips.
Read post →Are Google Sheets sexy now? Dropdown Chips might do the trick!
Replace typing with clicking. Instantly color-code options. Discover a revolutionary way to manage your lists with Google Sheets new dropdown feature!
Read post →Are You Frustrated With Sheets New Dropdown Chips?
Do those dropdown chips have you frustrated? They stand out far too much! Here's how you can change the look of your sheet instantly? With a few advanced options with Dropdown Chips in Google Sheets
Read post →Related terms
dropdowns / data validation
Data validation restricts what people can type in a cell. A dropdown is the friendly face of that feature: pick from a list instead of free text. It keeps statuses, categories, and owners consistent so filters, pivot tables, and scripts do not break on typos.
Read guide →Data validation
Data validation restricts what can be entered in a cell before bad data spreads through your model. Rules can enforce dropdown lists, number ranges, dates, text length, or custom formulas that return TRUE. Invalid entries can be rejected or warned with a note. Validation is the front door quality check for shared trackers and intake sheets.
Read guide →filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fastest UI path. FILTER and QUERY formulas build dynamic views that update when source data changes, which suits dashboards and reporting tabs.
Read guide →Explore tab
The Explore tab is a sidebar panel that analyzes your selected data and suggests charts, pivot tables, formatting, and quick questions. Google Sheets opens it from the star icon or when you select a table range. It is a fast way to visualize patterns without writing formulas first.
Read guide →Done reading about Chip?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.