SharePoint Document Issues

Fix SharePoint Conditional Column Formula Not Showing a Field

Muhammad Talha Oct 22, 2026 868 views

Question details

The user needs to display a specific SharePoint list column (e.g., Accrual Rate) only when another column (e.g., PTO) has a specific value selected, but the conditional formatting formula fails to reveal the target column.

Fix SharePoint Conditional Column Formula Not Showing a Field

Product: SharePoint
Device & OS: not provided
Scenario: Configuring a SharePoint list form using conditional formatting so that secondary data fields dynamically appear based on user selections in a choice column.
Observed behavior: The target column remains hidden or unresponsive on the list form despite a conditional formula being applied to it.

Before you start

Ensure you have 'Edit' or 'Full Control' permissions for the SharePoint list, and verify that you are editing the form in the modern SharePoint interface.

Solution 1Recommended

Verify Column Types and Correct Formula Syntax

Check that both columns use supported data types and that the formula references the exact internal column name rather than its display name.

SharePoint conditional formatting requires precise syntax. If a column was renamed, its internal name in the system remains the original name. The formula will fail if you use the display name.

Check the internal column name

Click the gear icon and select 'List settings'. Click on your trigger column (e.g., PTO). Look at the end of the URL in your browser's address bar for 'Field=' to find the exact internal name.

Ensure supported column types

Verify that your trigger column is a standard 'Choice' column and the target column is a 'Single line of text' or another supported type.

Edit the conditional formula

Return to the list view, select the target column header (e.g., Accrual Rate), choose 'Column settings', and then 'Edit conditional formula'.

Apply the correct syntax

Enter the formula using the internal name and single quotes for text values. For example: =if([$PTO]=='Non-Standard Accrual', 'true', 'false'). Click 'Save' to apply the changes.

Verify Column Types and Correct Formula Syntax

Syntax Requirement: Always prepend the internal column name with a dollar sign ($) inside the square brackets in your formula.

Solution 2

Test Formatting in a New SharePoint List

If the formula syntax is perfect but the field still doesn't appear, testing in a blank list can rule out corruption or conflicting view formatting in the original list.

Free Microsoft Office alternative

Enhance Your Document Management with WPS Office

While SharePoint lists are excellent for tracking data, managing the actual documents stored in SharePoint requires a robust office suite. WPS Office is a lightweight, free alternative to Microsoft Office that easily handles documents, spreadsheets, and presentations.

1. Download the installer: Visit the official WPS website and click the 'Download' button to get the free installation package.
2. Install the software: Run the downloaded installer and follow the simple on-screen instructions to set up WPS Office on your device.
3. Open your SharePoint documents: Download your files from SharePoint and open them in WPS Office to begin editing immediately with full format retention.

Fully compatible with Microsoft Word, Excel, and PowerPoint file formats (.docx, .xlsx, .pptx).Lightweight installation ensures fast loading times and smooth document editing.Familiar user interface makes transitioning from Microsoft Office completely effortless.Easily edit, annotate, and collaborate on files downloaded directly from your SharePoint document libraries.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my SharePoint conditional formula not working even though the syntax looks correct?

The most common reason is referencing the column's display name instead of its internal name. If a column was created as 'Choice 1' and later renamed to 'PTO', its internal name remains 'Choice_x0020_1'. You must use the internal name in the formula.

Which column types are not supported for conditional formatting in SharePoint?

While most standard columns like Choice, Text, and Number are supported, complex columns such as Person or Group (with multiple selections allowed), managed metadata, or certain calculated columns may behave unpredictably or are unsupported in basic conditional form formulas.

Can I hide a column based on multiple conditions?

Yes, you can use logical operators like '&&' (AND) or '||' (OR) in your formula. For example, to show a column when PTO is 'Non-Standard' AND Status is 'Active', you would use: =if([$PTO]=='Non-Standard' && [$Status]=='Active', 'true', 'false').

Does hiding a column with conditional formatting delete its data?

No. Conditional formatting only controls the visibility of the field on the list form. Any data previously entered into that column remains securely stored in the list and can still be accessed via list views or exports.

Document & File Issues