How to Create a Choice Column in SharePoint
A Choice column gives users a fixed list to pick from. It’s the workhorse of clean SharePoint metadata — fast, consistent, and easy to filter.
What it is
A Choice column lets you define a fixed set of options (Draft, In Review, Approved, Archived) and forces users to pick from that list rather than typing whatever they want. The result is consistent data: every file tagged with one of the same five options, no typos, no variations, ready to filter and sort cleanly.
Choice columns are perfect when you have a small, stable list of categories specific to one library or site. Document Status, Approval Stage, Priority Level, Phase — all natural Choice columns. They’re not the right tool when the list is shared across the tenant (use Managed Metadata) or when items are people (use Person), but for local categorisation they’re hard to beat.
The setup conversation matters as much as the technical choice. Before adding a Choice column, ask: what are the actual options? Get the team to agree on the list. Six options is a sensible upper limit for most use cases — if you have twelve, you probably have two columns hiding in one. If you have three, you probably have a Yes/No.
When to use this
- When you have a fixed list of options for one library or site.
- For Status, Document Type (within one library), Priority, Phase, Approval Stage.
- When you want users to pick from options rather than typing freely.
- When you want filterable, reportable categories without setting up the term store.
How to do it
- Open the library and click + Add column.
- Select Choice.
- Type your options, one per line.
- Choose display: drop-down (most common), radio buttons, or checkboxes (for multi-select).
- Set a default value if it makes sense (e.g. ‘Draft’ for a Status column).
- Decide whether to allow ‘fill-in’ values — usually no, because it defeats the consistency.
- Save and apply colour formatting if you want visual cues in views (see M-44).
Best practices
- Keep the list short. 5-8 options is the sweet spot. More than 10 and users start ignoring the column.
- Use a sensible default. ‘Draft’ for Status, ‘Internal’ for Sensitivity. Saves a click for the most common case.
- Apply colour formatting for visual scanning. Red for ‘Blocked’, green for ‘Approved’. Makes views immediately readable.
- Don’t allow fill-in values unless you must. The whole point of Choice is consistency.
Common mistakes
- Long lists of options. If you have 20 choices, you probably need a hierarchy (Managed Metadata) or two columns.
- Allowing fill-ins without a plan. Users add inconsistent values that pollute your reports.
- Using Choice across many libraries. If the same list is used in 5 libraries, use Managed Metadata so it stays in sync.
The File Sanity Kit gives you the Container Method™ — audit, restructure, and future-proof SharePoint without IT admin. The complete methodology, full workbook, and 8-tab Excel planner.
Get the File Sanity Kit — $27 →FAQ
What is a Choice column in SharePoint?
A Choice column gives users a fixed list of options to pick from (Draft / In Review / Approved / Archived, for example). The list lives inside one library and is maintained by the library owner. Users can’t type new values — they pick from what you defined — which keeps the data consistent and makes filtering, sorting, and reporting reliable.
Can users add their own options to a Choice column?
Only if you turn on the ‘Allow fill-in choices’ setting — which we don’t recommend. Letting users add fill-in values defeats the whole reason you used a Choice column in the first place: consistency. Within a few weeks the list drifts (slightly different spellings, casual variants), and you’re back to the chaos of a text column. Leave fill-in OFF and update the choice list properly when you genuinely need new options.
How many options should a Choice column have?
Three to seven is the sweet spot. Under three and you probably want a Yes/No column. Over about ten and the list becomes unwieldy — users scroll, get lost, and start picking ‘Other’ to escape. If you genuinely have twelve categories, you probably have two columns hiding inside one (e.g. Status + Stage). Split them out.
Can a Choice column show as radio buttons or checkboxes?
Yes. When creating the column, choose Display choices using: Drop-Down (compact, default), Radio Buttons (everything visible, single pick), or Checkboxes (multi-select). Radio buttons are good for short lists where you want users to see all options at a glance. Checkboxes are for cases where a file can legitimately have multiple values (e.g. multiple topics).