Overview
The Percent field is a numeric field type that holds numerical values formatted as percentages. Simply type in the whole number you wish the percent to be, and it will automatically be displayed as a percentage (no need to type decimals).
For a standard numeric field, consider using the Number field type instead.
Plan Availability | All plan types |
Permissions | Workspace Admins, Solution Creators and Solution Managers: Can create, modify, delete, and manage Percent fields in their solutions. |
Related Reading |
Adding a Percent Field
From Grid View
Navigate to the table where you want to add the Percent field.
Click the + Add Field button.
Select Percent Field from the field options.
Name the field and configure its settings as needed.
Save your changes.
From Record View
Open the record where you want to add the Percent field.
Click the Edit Fields button.
Add a new field by selecting Percent Field.
Configure and save the field settings.
Formatting Options
From the field modification settings, you can customize the following:
Precision:
Choose the number of decimal places to display (default is "0.00").
Thousands and decimal separators
Choose the format of decimal separators
Negative Values:
Allow or disallow negative percentages.
Display thousands separator
Specify whether the thousands separator is displayed
Required Field:
Specify whether the field requires an entry.
Check out quick articles on Setting Default Field Values and Adding Help Text to fields.
Copying and Exporting Percent Values
The Percent Field displays values as integer percentages, for example 50% or 75%. When you copy or export the field value, be aware of how it is represented:
Copying the contents of the field from the UI will provide a formatted text value, such as 50%.
Exporting the data to CSV, Excel or Google Sheets will include the decimal representation of the percentage, for example 0.50 (instead of 50%) to make it easier to perform calculations that use the percentage.
Practical Scenarios and Use Cases
1. Departmental Performance Tracking
Scenario: A sales department needs to track monthly revenue goals as percentages.
Solution: Use the Percent field to record and calculate monthly achievements compared to goals, providing clear insights.
2. Grade Calculation
Scenario: An educational institution tracks student grades as percentages.
Solution: Use Percent fields in a Rollup to calculate individual and overall grade averages across courses.
3. Financial Analysis
Scenario: A company analyzes profit margins by product.
Solution: Use Percent fields to input and analyze profit margin percentages for detailed financial insights.
Example of Use
SmartSuite recognizes Percent field values in:
Saved Views
Formula Fields
Rollup Fields
Practical Example:
Roll up individual grades from linked courses to calculate a current grade average.