A Yes / No field holds one of two states on a record. Think of a box on a checklist that is either checked or not.
Here is the test: is the answer always one of two things, with nothing in between? If yes, you want a Yes / No field. For a scale, use a Rating field. For a list of possible answers, use a Single Select field.
Example: a Vendors table with a field called SOC 2 Report On File. Yes means Security has the vendor's current report. A view filtered to No lists the vendors to chase.
The SOC 2 Report On File field in a vendor record, showing the green check for Yes.
Plan Availability | All plan types. |
Permissions | Solution Managers and Workspace Administrators can create, modify and manage Yes / No fields. |
Platform | Web |
Related Reading |
Adding a Yes / No Field Type
In Grid View, select the + at the right end of the column headers. From an open record, select + Add new field to this Table at the bottom instead.
Select Yes / No. You can type to search the list of field types.
Name the field. In this article it is SOC 2 Report On File. A field name can hold up to 50 characters, and there is no restriction on the characters it can contain.
The field settings panel opens. It has three tabs: Settings, Defaults and Help Text. 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 and Color.
Settings
The Settings tab holds how the two states look. Top to bottom: Display Format and Color. There is no Options section on this field, and no Require switch: every record holds Yes or No from the moment it is created.
Display Format
How the two states look in a record and in views. The dropdown shows both states of the current format. Open it to pick one of eight:
Checkmark (the default): a check for Yes, nothing for No.
Heart, Thumbs Up, Star and Flag: the icon filled for Yes, faint for No.
Round Toggle: a switch.
Rectangle Toggle: a switch labeled ON and OFF.
Yes / No Toggle: a switch labeled YES and NO.
Use Checkmark for a flag people scan down a column, such as SOC 2 Report On File. Use a toggle format where people flip the value often and want to see both states.
The Display Format dropdown open, showing the eight formats with their Yes and No states.
Color
The color of the Yes state. The section title shows the current swatch. Pick from the 20 swatches below it; the default is green.
Tip: Keep green for flags where Yes is good news, such as a report on file. Pick a warm color where Yes means attention, such as a field called Has Open Findings.
Defaults
Default State is the state every new record starts with. It is a toggle, set to No to begin with. Switch it to Yes when Yes is the common case.
Note: Defaults apply to new records only. Records that already exist do not change when you set or change a default.
SOC 2 Report On File keeps No, so a new vendor shows as unverified until Security sets it.
Help Text
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 SOC 2 Report On File: "Set Yes only when the current SOC 2 report is attached under Files. A bridge letter does not count."
Permissions
Two kinds of permissions apply to this field.
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 Security set SOC 2 Report On File while everyone else reads it. See Field Permissions.
Dynamic Record Permissions. A Yes / No field can drive record-level rules: who can see or edit a record based on its state. A rule such as "records where SOC 2 Report On File is No are visible only to the Security team" uses the field as the condition. Every field type except Button can drive a rule. See Dynamic Record Permissions.
Using the field in views and records
Once the flags are set, the field answers "which ones?" across the table.
In a record, select the control to switch it. With Checkmark, a faint square turns into a green check for Yes. Save the record to keep the change. In Grid View, a No cell is empty and a Yes cell shows the check. Click the value in the cell, or press Enter on the highlighted cell, to switch it. To set many records at once, set one cell and drag the fill handle down. See Fill cells with the fill handle.
A vendor record with SOC 2 Report On File set to Yes, next to a grid column with a mix of checked and empty cells.
Filtering
Filter the view on the field's state. The only operator is is, with Yes or No as the value; is not, is empty, is not empty and contains are not offered. "SOC 2 Report On File is No" lists every vendor without a current report. Save it as the view Security works from.
Grouping
Group a view by the field and the records split into two groups, Yes and No, each with a count.
Sorting
The column menu has two sort entries, shown as icons: checked to empty, and empty to checked. Sort empty to checked to put the vendors without a report at the top.
Counting and rolling up
A Count field on a Programs table can count the vendors with a report on file, by filtering on the field. The field also works in Lookup fields and in the filters of Count, Lookup and Rollup fields.
Formulas
A formula can branch on the field. This one labels each vendor:
IF([SOC 2 Report On File] = "Yes", "Report on file", "Chase report")
The field reads as the text Yes or No, and also as TRUE and FALSE, so [SOC 2 Report On File] = TRUE matches the same records. In CONCAT it gives Yes or No.
Automations
An automation can set the field with an Update records action; add the field under Fields to update. It can also use the field as a trigger condition. When SOC 2 Report On File changes to Yes, an automation can set the vendor's Review Status to Ready. See Automation Actions explained.
Forms
The field can sit on a form, and a follow-up field can show only when the answer is Yes. In the form builder, select the follow-up field, turn on Show field only when conditions are met and add the condition. See Conditional Fields & Sections in Forms.
Editing a Yes / No field
Switch one record. Select the control in the record and save, or click the cell in Grid View.
Change the look. Open Modify Field Settings, pick another Display Format or Color, then Update Field. Every record shows the new look; the stored states do not change.
Change the default. On the Defaults tab, switch Default State. Existing records keep their state.
Change the field type. A Yes / No field can become a Text, Text Area, SmartDoc, Single Select or Multiple Select field. It cannot become a Number, Status, Tags or Checklist field. See Changing a Field's Type.
Note: There is no blank state. A record nobody has reviewed reads No, the same as a record reviewed and found missing. Pair the field with a date field, such as Last Verified, when "not checked yet" matters.
Frequently asked questions
Is there a plain checkbox format?
Is there a plain checkbox format?
Checkmark is the closest: a check for Yes, nothing for No. There is no separate checkbox format.
Can I make the field required?
Can I make the field required?
There is no Require switch, because every record already holds Yes or No. Use the Default State to choose which one a new record starts with.
How do I set several records at once?
How do I set several records at once?
In Grid View, set one cell and drag the fill handle down. The value copies to the records below.
Can an automation update the field?
Can an automation update the field?
Yes. Add an Update records action and put the field under Fields to update.
Can a form question depend on the answer?
Can a form question depend on the answer?
Yes. Turn on Show field only when conditions are met on the follow-up field and add the condition that this field is Yes.
I need a third state, such as Not Applicable.
I need a third state, such as Not Applicable.
Use a Single Select field with the three choices instead. A Yes / No field holds two states only.
Last verified 30 Oct 2026.




