How to Use WPS Progress Field on macOS

Use Progress Field in 4 how-to topics, covering field creation, percentage entry, drag adjustment, and calculations; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Create a Progress Field

Entry: + button on the right side of the header → field type list → Progress

1. Open the Smart Table data sheet you want to edit.
2. Click the + button on the right side of the header.
3. In the field type list, select Progress.
4. Enter a field name.
5. Click Confirm to finish creating the field.

Success Criteria

• Interface result: A new Progress Field column appears in the table.
• What you can do next: You can type percentages or drag the progress bar in that column.

Tips While Using

• Use a clear field name such as Completion or Project Progress.
• Progress Field is intended for values between 0% and 100%.

2. Enter a Progress Percentage

Entry: target cell → type a percentage directly

1. Click the target cell in the Progress Field column.
2. Type a percentage value such as 60%.
3. Press Return or finish the input.
4. Check the progress display in the cell.

Success Criteria

• Interface result: The cell shows the percentage and matching progress fill.
• What you can do next: You can continue updating progress values for other records.

Tips While Using

• Keep the same percentage format across records for easier comparison.
• Keep values within the 0% - 100% range.

3. Drag the Progress Bar to Adjust Completion

Entry: target cell → drag the progress bar

1. Click the target cell in the Progress Field column.
2. Find the adjustable progress bar inside the cell.
3. Drag the bar left or right.
4. Release the mouse to keep the current completion value.

Success Criteria

• Interface result: The bar length changes with the drag position.
• What you can do next: You can fine-tune the value until it matches the target completion level.

Tips While Using

• Dragging is useful for quick status updates.
• If you need an exact value, combine dragging with direct percentage input.

4. Use Progress Field in Calculations

Entry: reference the Progress Field in a formula or summary workflow

1. Make sure the Progress Field already contains valid percentage data.
2. Choose the formula or summary method you want to use.
3. Reference the Progress Field as a numeric field in sum, average, or similar calculations.
4. Review the result and confirm that it matches your expectation.

Success Criteria

• Interface result: The calculation returns a usable numeric result.
• What you can do next: You can continue with filtering, grouping, or summary analysis.

Tips While Using

• Progress Field is stored as a numeric value and can be used in common numeric calculations.
• Consistent input formatting helps keep summary results more reliable.