Others

Fix Invalid Condition Formula for Hiding a Microsoft Lists Column

Maira Mehtab Sep 20, 2026 869 views

Question details

The user is encountering an 'Enter Valid Condition' error when trying to use a formula to conditionally hide the Assumptions text column based on a Yes/No choice in the BRD Approval column.

Product: Microsoft Lists
Device & OS: not provided
Scenario: Configuring list form layouts by setting up conditional formatting rules to show or hide specific columns dynamically.
Observed behavior: The system rejects the formula and throws an 'Enter Valid Condition' error, preventing the conditional visibility from being applied.

Before you start

Before editing your formula, ensure you know the exact internal name of your columns, as Microsoft Lists uses internal names rather than display names for conditional formulas.

Solution 1Recommended

Verify Internal Column Names and Formula Syntax

Incorrect field references, such as typos in the column name or using the display name instead of the internal name, are the most common cause of validation errors in Microsoft Lists.

Microsoft Lists requires strict syntax for conditional formatting. If your column was originally created as 'BRD Approved' and later renamed to 'BRD Approval', its internal name remains 'BRD Approved'. You must use the internal name in your formula.

Locate the internal column name

Click the gear icon to open 'List settings', scroll down to the Columns section, and click on your target column (e.g., 'BRD Approval'). Look at your browser's address bar; the text exactly following 'Field=' is your internal column name.

Access the conditional formula pane

Return to your list, click 'New' to open the item form, click the 'Edit columns' icon in the upper right, hover over the 'Assumptions' column, click the three dots (...), and select 'Edit conditional formula'.

Input the corrected formula

Enter the formula using the exact internal name. For a Yes/No column, the format is: =if([$InternalColumnName] == 'Yes', 'true', 'false'). Replace 'InternalColumnName' with your specific field, ensuring you include spaces as '_x0020_' if applicable.

Save and test

Click 'Save'. If the syntax and internal name are correct, the 'Enter Valid Condition' error will disappear, and the Assumptions column will now dynamically hide.

Check for common typos: Ensure you are using standard straight quotes (' ') rather than smart/curly quotes (‘ ’) in your formula, as Microsoft Lists will not recognize formatted quotes.

Solution 2

Confirm Configuration Environment and App Context

Ensure you are applying the formula in the correct Microsoft Lists interface, as syntax differs significantly between Microsoft Lists, Excel, and Microsoft Forms.

Free Microsoft Office alternative

Manage Data and Conditional Rules Effortlessly with WPS Office

If troubleshooting complex JSON formulas in Microsoft Lists is slowing you down, consider tracking and managing your data with WPS Spreadsheet. WPS Office offers a free, lightweight alternative with highly intuitive data validation and conditional formatting tools that require no coding.

1. Download WPS Office: Install the free WPS Office suite on your preferred device.
2. Create a Data Tracker: Open WPS Spreadsheet and format your data with built-in list templates.
3. Apply Visual Rules: Navigate to the Home tab and use 'Conditional Formatting' to visually manage your data without complex syntax.

Easily manage data lists with visual conditional formatting rules.Fully compatible with Microsoft Excel (.xlsx) file formats.Free, lightweight, and fast-performing Office suite.Familiar user interface ensures a seamless transition for Microsoft users.

microsoft office alternative - wps office

Frequently Asked Questions

Why am I getting an 'Enter Valid Condition' error in Microsoft Lists?

This error occurs when the formula syntax is invalid. Common reasons include missing brackets, using smart quotes instead of straight quotes, or using the display name of a column instead of its internal system name.

How do I find the internal name of a Microsoft Lists column?

Navigate to the List settings via the gear icon, click on your specific column, and check the URL in your browser's address bar. The exact text at the very end of the URL, following 'Field=', is the internal name.

Does renaming a Microsoft Lists column update its internal name?

No. Once a column is created, its internal name is permanently locked. If you originally named it 'BRD Approved' and later renamed it to 'BRD Approval', the internal name remains 'BRD_x0020_Approved'. You must use the original internal name in your formatting formulas.

Can I use formulas to hide columns based on multiple conditions?

Yes, Microsoft Lists supports complex conditions. You can nest 'if' statements or use logical operators (like && for AND, || for OR) inside the conditional formula pane to evaluate multiple column values.

Office Quick Solutions