SharePoint Document Issues

How to Set a SharePoint Conditional Display Formula for Form Questions

Muhammad Talha Sep 28, 2026 869 views

Question details

The user wants to configure a SharePoint form so that a specific question only displays when another field is set to a certain value.

How to Set a SharePoint Conditional Display Formula for Form Questions

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Customizing a SharePoint list form to conditionally show or hide a field when the Automation Request Type field is set to Query.
Observed behavior: The user requires the correct formula syntax and configuration steps to ensure the target field properly evaluates the condition and updates its visibility in the form.

Before you start

Ensure you have Edit or Owner permissions for the SharePoint list, and verify the exact internal name of the column you plan to reference, as it may differ from its display name.

Solution 1Recommended

Configure the Conditional Formula Using the Internal Field Name

Format your formula using the field's internal name with no spaces to ensure SharePoint evaluates the condition correctly.

SharePoint conditional formulas rely on internal column names to function properly. If a column was created with spaces in its name, the internal name usually removes these spaces or replaces them with special character codes.

Identify the internal field name

Determine the internal name of the reference field (e.g., Automation Request Type). Remove any spaces so it reads as a single string, such as $AutomationRequestType.

Enter the conditional formula

Navigate to the column you want to conditionally display, select 'Edit conditional formula', and enter the formula: =if([$AutomationRequestType] == 'Query', 'true', 'false').

Save the form configurations

Click 'Save' on the conditional formula dialog, and then ensure you also click 'Save' on the main 'Edit columns in the form' dialog to fully apply your changes.

Configure the Conditional Formula Using the Internal Field Name

Formula Syntax Checking: Always double-check that you are using straight single quotes (' ') around your text values, as curly or smart quotes copied from text editors can cause the formula to fail.

Solution 2

Troubleshoot Conditional Formula Errors

Verify syntax and check for common formatting mistakes if the field visibility does not change as expected.

Free Microsoft Office alternative

Enhance Your Document Workflow with WPS Office

While SharePoint is excellent for managing list forms and data, handling the actual exported reports or attached documents requires a reliable office suite. WPS Office is a lightweight, free alternative to Microsoft Office that provides a seamless experience for editing documents, spreadsheets, and presentations.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Install the application: Run the setup file and follow the on-screen instructions to complete the installation.
3. Open your SharePoint files: Launch WPS Office and directly open any Word, Excel, or PowerPoint files exported from your SharePoint lists.

Highly compatible with Microsoft Office formats (.docx, .xlsx, .pptx) exported from SharePoint.Lightweight design ensures fast opening of heavy data files and reports.Familiar, easy-to-navigate user interface for a zero-learning-curve transition.Rich built-in PDF editing tools for streamlined document management.

microsoft office alternative - wps office

Frequently Asked Questions

Why is my SharePoint conditional formula not working?

The most common reason is using the display name instead of the internal name. Ensure you remove spaces from the internal name (using [$AutomationRequestType] instead of [$Automation Request Type]) and verify your quotation marks are straight, not curly.

Can I use conditional display formulas for multiple conditions in a SharePoint form?

Yes, you can nest 'if' statements or use logical operators like '&&' (AND) and '||' (OR) in your SharePoint formula to evaluate multiple fields simultaneously.

Do conditional formulas affect SharePoint list views?

No, conditional display formulas only apply to the SharePoint list forms (the New, Edit, or View form panes). They do not hide or show columns in the standard grid or list views.

Document & File Issues