Sharepoint Calendar JSON

Question

Is there a JSON formula I can use to color the text of a choice fiend in a calendar list?

Example: I have a choice column with the options EROC or AROC - I would like EROC to be green text and AROC to be blue text on the calendar. What would the JSON be for that?

Thank you!

Answer 1

Hello @MeagLane ,

Welcome to Q&A Forum!

According to my research and search, We cannot set JSON formatting for Choice column in a Calendar list.
However, you could try to the below workaround:

Adding Colors to Event Categories with Overlay Feature:

1.Create a Choice column naemd "Types" and set it as the required field.

2.Create three Calendar Views

ALL view:

• Make this view the default and public view
• Filter: Title is equal to null(empty)

EROC view:

• Make this view the public view
• Filter: Types is equal to EROC

AROC view:

• Make this view the public view
• Filter: Types is equal to AROC

3.Go to the Calendar list, on the CALENDAR tab, click on Calendars Overlay.

4.On the Calendar Overlay Settings page, click on New Calendar to create two calendars

EROC:

• Please click "Resolve" button, and select the corresponding list and list view
• Select the "Always show" checkbox.

AROC:

• Please click "Resolve" button, and select the corresponding list and list view
• Select the "Always show" checkbox.

5.Go to the Calendar list, you will see as below:

Thanks,
Echo Du

================================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.