Others

Fix Microsoft Lists Conditional Formula Not Showing Choice Column

Emma Brown Sep 28, 2026 869 views

Question details

The user is trying to display a specific column in a Microsoft Lists form dynamically based on a dropdown choice, but the target column does not appear when the condition is met.

Fix Microsoft Lists Conditional Formula Not Showing Choice Column

Product: Microsoft Lists
Device & OS: not provided
Scenario: Configuring a Microsoft Lists form with a conditional formula to display a target column only when the 'Call Group' choice is set to 'referral'.
Observed behavior: The conditionally formatted column remains completely hidden on the form even after 'referral' is selected in the trigger column.

Before you start

Verify that you have sufficient List Owner or Design permissions to modify list settings and edit column configurations in your Microsoft Lists or SharePoint environment.

Solution 1Recommended

Correct Formula Placement and Column Requirements

This solution ensures the conditional formula is applied to the correct target column and that the choice column parameters meet Microsoft Lists' strict formatting requirements.

A common mistake when setting up dynamic columns is applying the formula to the trigger column instead of the target column you want to show or hide. Furthermore, Microsoft Lists imposes specific requirements on column types and naming conventions for conditional formulas to work.

Apply formula to the target column

Open your Microsoft Lists form, click 'Edit columns' from the top-right menu, and select 'Edit conditional formula' strictly on the column that should appear, not on the 'Call Group' trigger column.

Enforce single-select for Choice columns

Check your 'Call Group' column settings to ensure it is configured as a single-select Choice column. Microsoft Lists conditional formulas do not support multiple-selection Choice columns.

Verify the internal column name

Make sure your formula uses the internal name of the column, which may differ from the display name. To find it, open List Settings, click your column, and look at the text immediately following 'Field=' at the end of the URL.

Confirm exact value matches and language settings

Ensure your formula checks for the exact text string (e.g., 'referral'). If your SharePoint site default language differs from your user settings, the stored value may differ from the display value, causing the formula to fail.

Correct Formula Placement and Column Requirements

Formula Syntax Note: A correct conditional formula looks like this: =if([$InternalColumnName] == 'referral', 'true', 'false'). Ensure there are no extra spaces.

Free Microsoft Office alternative

Manage and Format Data Seamlessly with WPS Office

While Microsoft Lists handles specific SharePoint data tracking, you can organize, manage, and conditionally format your data sets offline or locally using WPS Spreadsheet. It provides a highly compatible, free, and robust alternative for data validation and logic-based formatting.

Free and lightweight alternative to Microsoft Office.High compatibility with Microsoft Excel (.xlsx) formats and advanced formulas.Powerful conditional formatting and data validation tools to dynamic lists.Familiar user interface for seamless migration with almost zero learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my conditional formula work with a multi-select Choice column in Microsoft Lists?

Microsoft Lists currently restricts conditional formulas from evaluating multiple-selection Choice columns. You must configure the trigger column to strictly allow a single selection for the logic to execute properly.

How do I find the exact internal name of my list column?

Navigate to List Settings and click on the specific column's name. Look at your browser's address bar; the internal name is the text string located at the very end of the URL, directly after 'Field='.

Can site language differences break Microsoft Lists conditional formulas?

Yes. If the SharePoint site's regional or language settings differ, the stored internal value of a Choice column might not match the display value you see, causing exact-match conditions in your formula to fail.

Office Quick Solutions