WPS Checkbox is a binary field type in smart spreadsheet data tables on Android; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 4 | Matches the number of rows in the How-to Index |
| Available without membership | 4 | Matches the number of Free rows in the index |
| Membership-related items | 0 | The current task set is available directly |
About This Feature
Overview
Checkbox is a field type in WPS Office smart spreadsheet data tables on Android. It is used to record two states: checked and unchecked. It works well for task lists, completion tracking, and other yes-or-no style records, and it can also be used with filters and formulas.
Core capabilities include:
- Create a checkbox field: set the field type to Checkbox while editing a table header.
- Toggle the checked state: tap the checkbox to switch between checked and unchecked.
- Filter records by status: show checked or unchecked records only.
- Use checkbox values in formulas: checked maps to 1 and unchecked maps to 0.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | An Android device that can run WPS Office normally |
| App version | The latest WPS Office version is recommended for full access to smart table entry points and field editing |
| Network | No mandatory network connection is required for local checkbox editing; keep a connection available if you need account sync or cross-device viewing |
| Other | You need to work inside a smart spreadsheet data table and have permission to edit the current table fields |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation method | Install WPS Office on your Android device, then open a smart spreadsheet data table to use checkbox-related features |
| Check after installation | Open WPS → open a data table → tap a header and confirm that Edit and Field Type are available |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In Android smart spreadsheet data tables, WPS supports creating a checkbox field, toggling its state, filtering by checked status, and using the field as 1 or 0 in formulas. | Microsoft Lists uses a Yes/No column that appears as a single checkbox and can be used with list sorting, grouping, and filtering. | Google Sheets on Android lets you insert checkboxes into spreadsheet cells for project tracking, attendance, and to-do lists. | Notion databases include a Checkbox property for true or false values in lightweight tracking workflows. | Adobe Acrobat Sign supports checkbox fields in forms and also supports checkbox group rules. |
| WPS Advantages | Advantage: WPS keeps field creation, state switching, filtering, and formula use in one data-table workflow on Android. Distinct: checkbox states can be referenced directly as 1 and 0 for follow-up calculations. | Compared with WPS: the official Microsoft page focuses on list column behavior and view management rather than a mobile data-table field workflow. | Compared with WPS: the official Google page focuses on inserting checkboxes into cells, with less emphasis on field-style management. | Compared with WPS: Notion is centered on database properties and true/false tracking, but the editing path differs from a spreadsheet field workflow. | Compared with WPS: Adobe is oriented toward PDF form authoring and signing rather than data-table field management. |
| Official Source | — | List and library column types and options | Add & use checkboxes on Android | Database properties | Checkboxes in Adobe Acrobat Sign |
Overall Conclusion
WPS Checkbox is a practical fit for Android data-table work because it combines field setup, state updates, filtering, and formula use in one mobile workflow. Other products also support checkbox-style input, but their official guidance is centered on list columns, spreadsheet cells, database properties, or PDF forms.
Use Cases
| No. | Scenario | Suitable for | Main need | How Checkbox helps |
|---|---|---|---|---|
| 1 | Task completion tracking | Team members, project contributors | Mark whether a task is done | Use a checkbox field to record done and not done states |
| 2 | Inspection result logging | Field staff, operations teams | Update checklist items quickly on mobile | Tap the checkbox directly in the data table |
| 3 | Status-based filtering | Managers, reviewers | View only processed or unprocessed records | Filter by checked or unchecked status |
| 4 | Formula-based counting | Data maintainers | Include status in calculations | Reference checkbox values as 1 and 0 in formulas |
| 5 | Cross-device follow-up | Mobile office users | Continue tracking after phone updates | Update checkbox status on Android and keep following the table through account sync |
Membership & Benefits
Free vs WPS Premium
| Capability | Free users | WPS Premium |
|---|---|---|
| Basic checkbox field use | ✅ Available | ✅ Available |
| Basic PDF features | ✅ Available | ✅ Available with a broader feature range |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | Broader access |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Daily records and lightweight task tracking | Free | Checkbox fields are available directly for basic table records |
| More cloud storage or broader office capabilities | WPS Premium | Suitable if you also need more storage and more advanced office features |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page