SharePoint Document Issues

Fix SharePoint Conditional Formula Not Showing or Hiding Columns

Nimra MalikNimra Malik Nov 2, 2026 869 views

Question details

The user is unable to successfully show or hide specific SharePoint list columns using conditional formatting formulas.

How to Fix SharePoint Conditional Formula Not Showing or Hiding Columns
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Applying conditional formatting formulas to show or hide columns in a SharePoint list based on specific text values.
Observed behavior
The target columns unexpectedly disappear or fail to format correctly, specifically affecting date and multiple-selection choice fields.
Before you start

Ensure you have the appropriate site owner or list editor permissions in SharePoint to modify list settings and column formatting.

Solution 1Recommended

Verify Supported Column Types for Conditional Formulas

Check if your SharePoint list columns are supported by conditional formulas, as certain types like multi-select choice columns have known limitations.

SharePoint conditional formulas do not support all data types natively. Complex fields, particularly multiple-selection choice columns and specific date/time formats, often cause the target columns to disappear when a formula is applied.

1
Access list settings

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

2
Review column data types

Scroll down to the 'Columns' section and review the data types assigned to the affected columns.

3
Identify unsupported columns

Check for column types known to have formatting limitations, such as 'Choice (menu to choose from)' where 'Allow multiple selections' is set to Yes.

4
Modify column configuration

Click on the unsupported column and change its configuration (e.g., disable multiple selections) or replace it with a standard text field to ensure compatibility with your conditional formula.

Verify Supported Column Types for Conditional Formulas
Column Limitations: Standardizing on single-value text or single-selection choice columns will resolve most visibility issues when using conditional formulas.
Free Microsoft Office alternative

Manage Complex Data Easily with WPS Office

If SharePoint list formatting becomes too restrictive or complex, consider managing your structured data and conditional rules in WPS Spreadsheet. It offers a familiar interface, highly customizable conditional formatting, and seamless compatibility with Microsoft Excel formats without the strict column-type limitations of SharePoint lists.

Advanced and intuitive conditional formatting without restrictive column-type limitations.Seamless compatibility with Microsoft Excel (.xlsx) files for easy data migration.Lightweight and free to use, offering a comprehensive suite for documents, spreadsheets, and presentations.Familiar user interface that requires zero learning curve for Office users.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my SharePoint list columns disappear when applying a conditional formula?

Columns usually disappear because the formula contains syntax errors, references an incorrect internal column name, or is applied to an unsupported column type like a multiple-selection choice field.

Can I use multiple-selection choice columns in SharePoint conditional formatting?

Currently, SharePoint conditional formatting formulas have limitations and generally do not support multiple-selection choice columns. You will need to change the column to a single-selection choice or standard text for the formula to work.

How do I find the internal name of a SharePoint column for my formula?

Go to your List Settings and click on the specific column name. Look at your web browser's address bar; the exact internal name is the text located at the very end of the URL immediately following 'Field='.