Others

How to Base a SharePoint Choice Column on a Calculated Column

Camila Milosovich Oct 10, 2026 869 views

Question details

The user wants a SharePoint Choice column to automatically display specific text values (like High, Medium, or Low) based on the numeric output of a calculated column.

Can a SharePoint Choice Column Be Based on a Calculated Column?

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Setting up a SharePoint list where column statuses are dynamically assigned based on numerical data thresholds.
Observed behavior: SharePoint does not natively allow Choice columns to be automatically populated by a calculated column, requiring a workaround to achieve dynamic status labels.

Before you start

Ensure you have the necessary permissions to edit list settings, create new columns, and access Power Automate if you plan to use workflow automations.

Solution 1Recommended

Use a Calculated Column That Returns Text

Since native Choice columns cannot pull data from a calculation, the best workaround is to create a new Calculated column that outputs text based on an IF formula.

This method replaces the need for a Choice column entirely by outputting the desired text strings natively within SharePoint list settings.

Access List Settings

Navigate to your SharePoint List and click on the 'Settings' gear icon in the top right, then select 'List settings'.

Create a New Column

Scroll down to the Columns section and click 'Create column'.

Configure the Calculated Column

Name the column (e.g., 'Status Indicator'), select 'Calculated (calculation based on other columns)' as the column type, and set the data type returned from this formula to 'Single line of text'.

Enter the IF Formula

Enter a nested IF formula in the formula box, such as =IF([NumericColumn]>80,"High",IF([NumericColumn]>50,"Medium","Low")), and click 'OK' to save.

Use a Calculated Column That Returns Text

Column Formatting: You can apply JSON column formatting to this text-based calculated column so it visually resembles the colored pills of a standard Choice column.

Solution 2

Use Power Automate to Update a Standard Choice Column

If you strictly need a native Choice column for filtering or third-party integrations, use Power Automate to evaluate the numeric column and update the Choice field.

Free Microsoft Office alternative

Streamline Your Document Workflows with WPS Office

While SharePoint handles your list management and data structuring, WPS Office is the perfect lightweight alternative to Microsoft Office for creating, editing, and sharing the documents stored in your SharePoint sites.

1. Download and Install: Visit the official WPS website to download the free installation package for your Windows, Mac, or Linux operating system.
2. Open Your Documents: Launch WPS Office and open your exported SharePoint documents or local files directly within the intuitive workspace.
3. Edit and Save: Enjoy full editing capabilities and save your files in standard Microsoft formats (.docx, .xlsx, .pptx) for seamless sharing back to SharePoint.

Highly compatible with Microsoft Word, Excel, and PowerPoint formats.Free and lightweight, ensuring fast performance on any operating system.Familiar user interface makes switching easy with zero learning curve.Built-in PDF editing tools for comprehensive document management.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't a standard SharePoint Choice column accept formulas?

SharePoint Choice columns are natively designed exclusively for manual user selection from a static list of predefined options. They lack the backend capability to evaluate dynamic formulas or reference other columns in real-time.

Can I make a calculated text column look exactly like a Choice column?

Yes. You can use SharePoint's column formatting feature to apply JSON code to your calculated text column. This allows you to add background colors, icons, and borders, making the text output visually identical to a native Choice column pill.

Does using Power Automate to update a Choice column require a premium license?

No. Updating a SharePoint list item using standard triggers and actions in Power Automate is included with most basic Microsoft 365 business licenses and does not require a premium connector.

Office Quick Solutions