A Percent Complete field holds a progress value from 0 to 100 and shows it as a bar. Think of the progress bar on a download.

Here is the test: is the answer how far along a piece of work is, and should people see it at a glance? If yes, you want a Percent Complete field. For a share or a rate with no bar, use a Percent field. For a value people drag on a scale, use a Number Slider field.

Example: a Findings table with a field called Remediation Progress. The owner of each audit finding moves the bar as the fix proceeds. A Rollup on the audit averages the progress of its findings.

The Remediation Progress field in a finding record, showing a green bar at 65% with the value at the right.

The field settings panel opens. It has three tabs: Settings, Defaults and Help Text. There is no AI Field Agent tab. The rest of this article takes them in that order. Save at any point with Add Field (or Update Field on a field that already exists) and come back to the other tabs later.

The field settings panel, Settings tab, with Display Format, Color and the Require an entry switch.

The Settings tab holds how the bar looks and one rule. Top to bottom: Display Format, Color and Options.

The size of the bar. The dropdown shows a sample bar at 38% in each size.

Use Large on a Card view, where the bar is the first thing people read. Use Small in a dense grid.

Two buttons: Solid Color (the default) and Gradient.

Remediation Progress keeps the default solid green, so the bar looks the same in every view. The red to green gradient is the alternative: a finding at 20% shows red and a finding at 90% shows green.

The Color section with Gradient selected and the four gradient bars.

One switch, off to start.

Require an entry in this field. On, the field shows a REQUIRED label and a record cannot be saved until a value is entered. Leave it off for Remediation Progress, where a new finding starts at 0 by default and the bar fills over time.

Default Value is the value every new record starts with, typed as a number from 0 to 100 with the % sign shown beside it.

Remediation Progress defaults to 0. Every new finding starts with an empty bar, and the owner moves it as the fix proceeds.

A note for the person filling in the record, up to 800 characters. Help Text Appearance shows it As A Tooltip (the default, behind an info icon next to the field name) or Below The Field Name (always visible).

Write it for someone who has never seen the field. For Remediation Progress: "How far the fix has come, from 0 to 100. Set 100 only when the evidence is attached."

Field Permissions. Every field can carry its own permissions, which control who can see the field and who can edit it. Open the column menu and select Edit Field Permissions. Let finding owners edit Remediation Progress while the audit team reads it. See Field Permissions.

Dynamic Record Permissions. A Percent Complete field can also drive record-level rules: who can see or edit a record based on the value it holds. Every field type except Button can drive a rule. See Dynamic Record Permissions.

In a record, the field is one box holding the bar with the value at its right. In Grid View, an empty cell shows a gray bar. Double-click the cell and a knob appears at the left of the bar. Type a number from 0 to 100 and the bar fills to match, with a bubble above the knob showing the number. Press Enter to save. The saved cell shows the colored bar and the value, such as 65%. A value outside the range is clamped: 150 is stored as 100 and -5 as 0. Decimals are not kept: 50.5 is stored as 50.

A grid cell being edited, with the knob, the bubble showing 65 and the bar filled to match.

The operators are is equal to, is not equal to, is greater than, is less than, is equal or greater than, is equal or less than, is empty and is not empty. A view of the findings whose Remediation Progress is less than 50 is the list for the next status meeting.

Group by this Field puts one group per value. Values vary widely, so group by a Formula that bands them instead, such as Not started, In progress and Done.

Sort 1 → 9 or 9 → 1 from the column menu. Sort 1 → 9 puts the findings with the least progress first.

A Rollup on the Audits table with Average gives the audit's overall progress from its linked findings, and updates as each bar moves. The field also works in Lookup fields, on Linked Record cards and in the filters of Count fields. See Rollup Field.

In a formula the value is a fraction: 70% is 0.7. This formula turns the bar into a status:

An Update records or Create a record action can write the field. It can set a value, or add, subtract, multiply or divide the current one. See Automation Actions explained.

A Percent Complete field can be placed on a form. See Form View.

Change a value. Double-click the grid cell or open the record, type the new number and press Enter.

Change the size or color. Open Modify Field Settings, pick another Display Format or Color, then Update Field. The stored values do not change; only how the bar shows.

Set a default. Open the Defaults tab, type the value and select Update Field. Records that already exist keep their values.

Change the field type. A Percent Complete field can become a Number, Percent, Text, Text Area or SmartDoc field. It cannot become a Currency, Number Slider, Rating, Duration or Single Select field. See Changing a Field's Type.

Delete the field. Open the column menu and select Delete Field. The values go with it. Deleted fields sit in the Recycle Bin for 30 days.

Need more help? Ask the SmartSuite Community, where builders, administrators and the SmartSuite team answer questions about building on SmartSuite. For your account, billing or data, select the chat button in the lower-right corner of SmartSuite to reach support.

Last verified 1 Nov 2026.