How to Use WPS Data Table Numbers on Android

Last updated:July 24, 2026

Use WPS Data Table Numbers through 3 how-to topics, including creating a number field, entering numbers, and using a number field in formulas.

How-to Index

No.TopicMembership Requirement
11. Create a number fieldFree
22. Enter numbersFree
33. Use a number field in formulasFree

How-to Guide

1. Create a number field

Entry: Tap the table header → Edit → Field Type → Number

  1. Tap the header that you want to configure.
  2. In the floating toolbar, tap Edit.
  3. In the field editing window, tap Field Type.
  4. Select Number.
  5. Enter the field name and confirm to finish the setup.

Success Criteria

  • Interface result: A new number field column appears in the table.
  • Next action available: You can enter numeric values in records under this field.

Tips While Using

  • Use a clear field name such as Amount, Quantity, or Hours.
  • If you need a currency symbol later, switch to a currency field when appropriate.

2. Enter numbers

Entry: Tap the target cell → Record details → Number field

  1. Tap the target cell to open the record details.
  2. Tap the number field that you want to fill in.
  3. Enter the numeric value.
  4. Return to the table to review the result.

Success Criteria

  • Interface result: The entered value appears in the number field.
  • Next action available: The value can be used for filtering, summaries, or formula references.

Tips While Using

  • Enter numeric content directly and avoid mixing notes into the value.
  • Number display formatting is not adjusted on mobile at this time.

3. Use a number field in formulas

Entry: Add or edit a formula field in the multi-dimensional table

  1. Open the multi-dimensional table that contains the number field.
  2. Create a formula field or open an existing formula field for editing.
  3. Select the number field that you want to reference in the formula.
  4. Save the formula settings.
  5. Return to the table and review the calculated result.

Success Criteria

  • Interface result: The formula field returns a calculated result.
  • Next action available: When the number field changes, the related result can update accordingly.

Tips While Using

  • Keep the referenced field as a number type before using it in calculations.
  • If the result looks incorrect, check the field type and entered values first.