Fix SharePoint Calendar View Conditional Formatting with Custom Columns
Question details
The user needs to apply JSON conditional formatting to a SharePoint calendar view based on a custom column's value rather than the default Title column.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Customizing calendar view entries with specific colors based on a custom column (e.g., 'Activity') using JSON code.
- Observed behavior
- The JSON formatting fails to apply the expected colors when the default 'Title' column is replaced with a custom column in the code.
Ensure you have the correct list management permissions to edit views in SharePoint, and verify the exact internal name of your custom column, as it often differs from its display name.
Verify the Column Internal Name and Supported JSON Properties
Check that your JSON code uses the column's exact internal name rather than its display name, and ensure the column type is supported in calendar views.
SharePoint JSON formatting relies strictly on the internal names of columns. When you create a custom column like 'Activity', its internal name might contain special characters or differing capitalization. Additionally, calendar views have strict schema limitations regarding which column types can be referenced for conditional formatting.
Navigate to your SharePoint List or Microsoft List, click the gear icon for Settings, and select 'List settings'.
Scroll down to the Columns section and click on your custom column (e.g., Activity). Look at the URL in your browser's address bar; the text at the very end after 'Field=' is the internal name of your column.
Return to your Calendar view, click the view dropdown menu, select 'Format current view', and choose 'Advanced mode' to edit the JSON code.
Replace the placeholder or 'Title' reference in your JSON code with the exact internal name you found in the URL, then save the view.
Consult the Microsoft Q&A Community for Custom Development
If your JSON schema is complex or continues to fail, leverage the Microsoft Q&A developer community for specialized code troubleshooting.
Try WPS Office for Seamless Productivity and Data Management
While SharePoint handles complex web-based lists, managing schedules, data, and conditional formatting is often faster and simpler in a dedicated spreadsheet tool. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office, allowing you to create formatted calendars and track activities without writing JSON code.
- 1. Download and Install: Visit the official WPS website to download the free suite and follow the simple installation prompts.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel (.xlsx) trackers, lists, or calendars.
- 3. Apply Formatting Visually: Use the built-in Conditional Formatting menu under the Home tab to instantly color-code your data without needing to write JSON.
Frequently Asked Questions
Why doesn't my JSON formatting work when I change 'Title' to another column?
This usually happens because the JSON code references the column's display name instead of its internal name. You must find the column's internal name via the List Settings URL and use that exact string in your JSON schema.
Can I use conditional formatting on all column types in a SharePoint calendar?
No. Microsoft Lists and SharePoint calendar views have strict schema limitations. Some complex field types, such as multi-select Choice columns or Lookup columns, may not be fully supported in calendar view formatting.
How do I find the internal name of a SharePoint column?
Go to your List Settings, click on the column name you want to reference, and check the URL in your web browser. The string following 'Field=' at the end of the URL is the column's internal name.
Is it possible to color-code SharePoint calendar events without JSON?
In modern SharePoint, conditional formatting in calendar views generally requires JSON. However, the basic view formatting wizard can sometimes generate the necessary code for you if you are only using supported default fields.
