Fix SharePoint Conditional Formula Not Showing or Hiding Columns
Question details
The user is unable to successfully show or hide specific SharePoint list columns using conditional formatting formulas.

- 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.
Ensure you have the appropriate site owner or list editor permissions in SharePoint to modify list settings and column formatting.
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.
Navigate to your SharePoint list, click on the Settings gear icon in the top right corner, and select 'List settings'.
Scroll down to the 'Columns' section and review the data types assigned to the affected 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.
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.

Check Formula Syntax and Internal Column Names
Ensure that your conditional formatting formula uses the correct syntax and references the exact internal names of the SharePoint columns.
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.

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='.




