Google Sheets can’t put more than one checkbox in a single cell: each checkbox is its own cell with a TRUE or FALSE value. To tick off several items inside one cell, use a multi-select dropdown instead. Select the cell, choose Insert > Dropdown, add your options, and tick Allow multiple selections under Advanced options. Each choice then shows as a chip in the same cell.
Quick Answer
Insert > Dropdown > add options > Advanced options > Allow multiple selections > Done. If you need real checkboxes, put one per cell in neighbouring columns.
Option 1: Multi-Select Dropdown in One Cell
- Select the cell or column.
- Choose Insert > Dropdown (or Data > Data validation).
- Type each option, and pick a colour for each if you like.
- Open Advanced options and tick Allow multiple selections.
- Click Done. Click the cell and tick as many options as you need.
Option 2: One Checkbox per Cell
- Put each item in its own column header, such as Packed, Booked van and Cleaned.
- Select the cells under them and choose Insert > Checkbox.
- Tick boxes as each step is done. Count them with
=COUNTIF(B2:D2, TRUE).
Option 3: Checkbox Symbols as Text
For a printable list, type symbols such as ☐ and ☑ in the cell, separated by line breaks (Ctrl + Enter). They look like checkboxes but aren’t clickable, and formulas treat them as text.
Which to Use
| Option | Clickable? | Easy to count? | Best for |
|---|---|---|---|
| Multi-select dropdown | Yes | With formulas | Several choices in one cell |
| Checkbox per cell | Yes | Yes, COUNTIF on TRUE | Task trackers |
| Symbols as text | No | No | Printed lists |
Troubleshooting
- Allow multiple selections is missing: It’s offered for dropdowns, not checkboxes. Set up the rule in Sheets in a browser.
- Counting chips: Multiple selections are stored as text separated by commas. Use
=COUNTIF(B2:B20, "*Packed*")to count cells that include an option. - Need to count or clear checkboxes? See counting checkboxes and unchecking all boxes.
- Doing the same in Word? See multi-selection drop-downs in Word.
Frequently Asked Questions
Can Apps Script put several checkboxes in one cell?
No. Scripts can build workarounds like a sidebar, but a cell still holds only one checkbox.
Can I use custom values for a checkbox?
Yes. In Data validation, choose Checkbox and turn on custom cell values, such as Yes and No.
Do multi-select dropdowns work on the mobile app?
You can usually view them; creating the rule is easiest in a browser.
Summary
- Use a multi-select dropdown for several choices in one cell.
- Tick Allow multiple selections under Advanced options.
- Use one checkbox per cell when you need TRUE or FALSE values.
- Use symbols only for printed lists.
Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.