Google Sheets Checkbox on Mobile: Add, Use, and Fix

Yes—you can tap existing checkboxes in the Google Sheets app on an iPhone or Android device to mark them checked or unchecked. To set up a new checkbox, the dependable method is to open the sheet in Google Sheets on a computer and choose Insert > Checkbox; mobile app menus may not provide the same setup options.

What a checkbox does in Google Sheets

A Sheets checkbox is a cell control, not just a checkmark character or an image. By default, a checked box has the value TRUE and an unchecked box has the value FALSE. That means the cell can be used in formulas, filters, and conditional formatting as well as viewed as part of a checklist.

For example, a household task sheet might have the task name in column A and a checkbox in column B. A checked box beside “Take out recycling” records completion in a way that can be counted or used to update a status elsewhere. This is more useful than typing a symbol such as ✓, because the symbol is text and does not automatically switch between checked and unchecked states.

Checkboxes are stored in the spreadsheet itself. Once someone adds them, collaborators can usually see and change them from a supported mobile app, subject to the sheet’s sharing permissions and any cell protection.

How to check and uncheck a box on your phone

Open the spreadsheet in the Google Sheets app and navigate to the cell containing the checkbox. Tap the checkbox to change its state. A checked box becomes unchecked when tapped again. On a small screen, zooming in or selecting the cell carefully can help if the box is close to other content.

Use these steps when you are working with an existing checklist:

Open the file in the Google Sheets app and make sure you have permission to edit it.
Find the row you want, then tap the checkbox cell.
Look for the checkmark to appear or disappear, and confirm the change is visible before leaving the sheet.
If the change does not appear to save, check your connection and give the app a moment to sync.

Checkboxes can be useful on a phone precisely because you do not need to enter TRUE or FALSE manually. For instance, a volunteer coordinator can mark a shift as filled while away from a computer, or a shopper can tick items off while walking through a store. Avoid tapping a nearby cell or row heading by mistake; if the wrong item changes, tap that box again to restore its earlier state.

How to add checkboxes to a sheet

For the clearest setup, use Google Sheets in a desktop web browser. Select the cell or range where you want the boxes, then choose Insert > Checkbox. Each selected cell receives a checkbox. Selecting a range first is handy when you are building a list with one box per row.

For example, if tasks are listed in A2:A20, select B2:B20 before inserting checkboxes. You can then label column B “Done” and use the app to update the list later. Keep the checkbox column separate from task names and notes so it is easy to tap the right cell on a narrow screen.

Google Sheets’ phone and tablet interfaces can change over time, and app options can vary by device. If you do not see a checkbox-insertion option in the app, that does not mean the sheet cannot contain checkboxes: create them in the browser on a computer, then return to the app to use them. A mobile browser’s desktop-site mode is a possible workaround, but the interface may be cramped or may open the Sheets app instead. For a large range or a carefully configured sheet, a computer is generally less frustrating.

Checkbox values, formulas, and useful examples

The default TRUE/FALSE values let a checkbox drive simple calculations. With checkboxes in B2:B5, the formula below counts how many of those four tasks are checked. If two boxes are checked, it returns 2.

With checkboxes in B2:B5, count completed tasks using =COUNTIF(B2:B5,TRUE).

With task names in A2:A5 and checkboxes in B2:B5, the next formula divides the checked count by the number of task names. If all four task-name cells are filled and two boxes are checked, it returns 0.5, which can be displayed as 50% by formatting the result as a percentage.

With task names in A2:A5 and checkboxes in B2:B5, calculate the completion share using =COUNTIF(B2:B5,TRUE)/COUNTA(A2:A5).

These examples assume the default checkbox values. Google Sheets also allows custom checked and unchecked values through its data-validation settings on the desktop interface. If a checkbox is configured with custom text instead of TRUE and FALSE, formulas that test for TRUE may no longer count it as expected. Check the rule before copying a formula from another sheet.

You can also use a checkbox as a simple control for a summary or a filter. For example, a separate “Show completed” checkbox could be connected to formulas that display or count completed entries. That takes more setup than a basic checklist, but the underlying idea is the same: the box changes a cell value, and other spreadsheet features respond to that value.

Organize a checklist for mobile use

A sheet that works well on a computer may be awkward on a phone. Keep the checkbox column wide enough to tap, put the task description immediately beside it, and avoid placing several unrelated controls close together. Freeze a header row if the list is long so labels remain visible while scrolling. Short task descriptions are easier to scan than dense notes in the same row.

Consider who will update the sheet and how many people may edit it. For a shared packing list, one checkbox per item is straightforward. For a project where a task can be waiting, in progress, or blocked, a dropdown may communicate more than a binary checked-or-unchecked choice. A checkbox only answers a yes-or-no question; it does not record who completed a task or when unless you add separate columns or another process.

When collaborators use the file, agree on what “checked” means. In a stock list, it might mean “ordered,” not “received.” A short header or note can prevent readers from interpreting the same checkbox differently. Do not use a checkbox as a substitute for a record that requires a timestamp, an approver, or an audit trail.

Common mobile problems and fixes

The box will not change: Confirm that you have edit access. A viewer can open a sheet but cannot update its cells. A protected range may also prevent edits even when the rest of the file is editable.
The tap seems to select the cell instead: Zoom in and tap the box itself. On a crowded sheet, adjust column widths or move the checkbox into a dedicated column from a computer.
You see TRUE or FALSE rather than a box: The cell may contain typed text or a Boolean value without checkbox validation. Add the checkbox control to that cell from the desktop browser rather than assuming the text will turn into a box automatically.
A formula gives an unexpected count: Check whether the boxes use the default TRUE/FALSE values or custom values, and confirm that the formula range matches the checkbox range.
Changes are not appearing for other people: Check the device’s internet connection, allow time for syncing, and reopen the file if needed. Offline edits may wait until the device reconnects. Avoid having collaborators overwrite the same cell while troubleshooting.
There are checkmarks but no interactive boxes: A typed checkmark, emoji, or pasted symbol is not the same as a checkbox. Replace it with an actual checkbox if you need a cell that toggles and works with checkbox values.

Mobile app, browser, and alternatives

The Sheets app is the practical choice for checking a prepared list while away from a computer. A desktop browser offers the fuller setup experience, including inserting a range of checkboxes and managing data validation. A phone browser in desktop mode may expose more of the web interface, but it is not always comfortable to operate and can depend on the browser and device.

If you only need to show a visual mark and do not need formulas or toggling, a symbol or text label may be enough. If each item needs one of several statuses—such as “Not started,” “In progress,” and “Done”—a dropdown is a better fit than a checkbox. If users need to submit responses rather than edit a shared spreadsheet, a Google Form linked to a sheet may suit that workflow better. Choose based on the action people need to take, not just on which control looks familiar.

Frequently Asked Questions

Can I insert a checkbox in Google Sheets on iPhone?
Use Google Sheets in a desktop browser for the reliable setup path: select cells and choose Insert > Checkbox. The iPhone app is useful for checking and unchecking boxes already in the sheet, but its available setup controls may differ.

Can I use Google Sheets checkboxes on Android?
Yes. Open the spreadsheet in the Sheets app and tap an existing checkbox to toggle it, provided you have editing permission. For creating or configuring a group of checkboxes, use the desktop browser if the app does not show the needed option.

Why does my checkbox show TRUE or FALSE?
The cell may contain a Boolean value without checkbox formatting, or the checkbox control may have been removed. Add a checkbox to the cell in the desktop version of Sheets. Also check whether the cell is using a custom value rule.

Do Google Sheets checkboxes work offline on a phone?
Offline availability depends on the file and device’s offline settings. If the spreadsheet is available offline, edits may be stored on the device and synced after reconnection. Do not assume another collaborator can see an offline change until synchronization has completed.

How do I remove a checkbox?
In a desktop browser, select the relevant cells and remove the checkbox or its data-validation rule. Be careful to distinguish removing the control from simply changing its checked state; clearing or deleting cell contents can behave differently depending on the selection and interface.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.