SharePoint Document Issues

How to Populate a SharePoint Column Based on Choice Selection

WPS Content Manager Oct 9, 2026 869 views

Question details

The user needs to configure a SharePoint calculated column to automatically return different numerical values based on a text selection from a Choice column, such as Low, Medium, or High priority.

How to Populate a SharePoint Column Based on a Choice Selection

Product: SharePoint
Device & OS: not provided
Scenario: Configuring a SharePoint list or library to automatically assign numerical values based on specific priority levels selected from a dropdown.
Observed behavior: The user is seeking the correct formula and column settings to evaluate categorical priority text and output the corresponding number.

Before you start

Ensure you have Full Control or Design permissions for the SharePoint list or library to create new columns and modify list settings.

Solution 1Recommended

Use a Nested IF Formula for Calculated Columns

Create a calculated column using a nested IF function to evaluate the choice selection and output the corresponding number.

A calculated column allows you to execute Excel-like formulas directly within your SharePoint list. By using a nested IF statement, you can check the exact text of your Choice column and assign a distinct numerical value for each possible option.

Access List Settings

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

Create a New Column

Scroll down to the Columns section and click on the Create column link.

Configure the Calculated Column

Enter a name for the new column and select 'Calculated (calculation based on other columns)' as the column type.

Enter the Nested IF Formula

In the Formula box, enter the nested IF formula matching your exact choice options. For example: =IF(Priority="High - 1-3 Days",2,IF(Priority="Low - 1-2 Weeks",7,1))

Set the Return Type

Under 'The data type returned from this formula is', select Number, and then click OK to save the column.

Use a Nested IF Formula for Calculated Columns

Exact Match Required: Ensure that the column name referenced in your formula (e.g., 'Priority') and the exact text of your choices match the formula perfectly, including spaces, hyphens, and punctuation.

Free Microsoft Office alternative

Edit Your Exported SharePoint Lists with WPS Office

While SharePoint manages your lists and online files, you need a reliable suite to handle exported spreadsheets and data reports. WPS Office is a free, lightweight alternative to Microsoft Office that offers seamless compatibility and a familiar interface for all your data analysis needs.

1. Download WPS Office: Download and install WPS Office for free from the official website.
2. Export SharePoint Data: In your SharePoint list, click on 'Export to Excel' to download your populated choice columns as an .iqy or .xlsx file.
3. Open and Analyze: Open the downloaded spreadsheet in WPS Spreadsheets to continue analyzing and organizing your priority data.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily analyze and format data exported from your SharePoint calculated columns.Lightweight design ensures fast loading times for large spreadsheets.Familiar, easy-to-use tabbed interface for seamless migration without a learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my SharePoint calculated column returning a syntax error?

Syntax errors typically occur if there is a typo in the formula, unmatched parentheses, or if your regional SharePoint settings require semicolons (;) instead of commas (,) to separate formula arguments.

Can I use multiple choice columns in a single calculated column formula?

Yes, you can evaluate multiple columns by using the logical AND or OR functions within your IF statements, allowing you to assign a number based on the combined status of several choices.

Will a calculated column update automatically if I change the choice selection?

Yes, whenever a list item is edited and the choice value is changed, the calculated column will automatically recalculate and display the newly corresponding number upon saving.

Document & File Issues