Creating a Color Coded Calendar in SharePoint Online

By Eric Newell | July 19, 2014

Creating a color coded calendar in sharepoint online

To help support our Dynamics implementations for our customers, we create a SharePoint site for each customer so we can track all of the documents, requirements, team members, budgets/contracts, processes, project plan, etc.  One of the most important things we do with this site is to track the project team’s availability by using a calendar.  We started using the default calendar, and that was working fine, but we always wanted a way to be able to show a difference between certain calendar events.  For example, we want to differentiate between a holiday and a day off, so we’d like the holiday to show up with a different color on the calendar.

I started looking around for ways to do this and I messed around with a few code samples that never ultimately worked.  I’m not a developer, so I can only go so far down that road before I run out of options.  It turns out, there is a great way of accomplishing this that doesn’t require any code, thanks to a feature called “Calendar Overlay” that’s available in SharePoint 2010 and 2013.  The overlay function was designed to allow you to see multiple calendars in one calendar view.  If you set it up correctly, you can actually use it to color code categories in one calendar.  Here’s how you do it:

Using Calendar Overlay to Color Code Categories on a Calendar on SharePoint 2013/Online

    1. Use the “Add an app” function to create a Calendar application.  For this example, mine is called “Team Calendar”
    2. Go to List Settings and click on the Category column.  You’re going to want to rename these categories to whatever you want to color code.  I also recommend making it a required field otherwise the appointment may not show up on your overlay calendar.
    3. Now that you have the Categories set up, you need to create separate view for each category.  This is the part that isn’t terribly obvious and took me a while to figure out.  For example, one of my categories is called “Holiday”, so I need to create a new view for my calendar that has a filter on the Category “Holiday”
Here's where you set the filter to each category

Here’s where you set the filter to each category

    1. Once you have set up a view for category, you need to set up a new calendar view that will pull all your custom calendars together. I call this view “Overlay” and make it the default calendar view. You can accept the defaults when creating this calendar, but in the filter area, be sure to create a filter that’s not going to happen. You don’t want to have anything show up on this calendar by default because you are going to overlay the other calendars on top of it. If you don’t create the filter, every calendar event will be duplicated. For example, I create a filter that only shows the calendar when “Location” equals Hawaii. .
Calendar Overlay Button

This is where you’ll find the calendar overlay button on the ribbon bar

    1. Next you need to begin overlaying the calendars. To do this, go to your Overlay calendar view.  Click on the Calendars Overlay button on the Calendar ribbon bar
    2. At this point, you’ll be at the Calendar Overlay page, and you’ll need to click on “New Calendar” at the top of the page.  .
    3. On the Calendar Overlay Settings page, give the overlay a name (this is what the user will see on the side of the calendar view) and choose the color you’d like.  On the Web URL, you’ll need to click the “Resolve” button for the system to pull in calendars from this SharePoint site.  Then choose a list of “Team Calendar” and a list view of “Holiday” so it overlays the Holiday calendar view on top of your Overlay calendar view.
Calendar Name

Screenshot of the overlay settings page

  1. Follow this step for each of the calendar views until you have them all overlaying the overlay calendar.
  2. The final result shows you the team calendar with all of the different colors for each category you selected.
Team calendar

This is the result

This color-coded calendar has been a great addition to our SharePoint implementation site. There are lots of different ways you can use this feature – it’s great that we can do this without any custom code. Good luck and let me know if you run into any challenges.

Related Posts

Recommended Reading:

5.27.22 Dynamics GP

How to Run Drop Ship Sales in Dynamics GP

Need to Invoice the Customer before you get the invoice from the vendor? This The freight forwarder has contacted you […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release – Protecting G/L Accounts From Being Deleted

There are a lot of exciting New Features in Dynamics 365 Business Central 2022 Wave 1 Release to get excited […]

Read the Article
5.25.22 Financials

Rounding Numbers in Power Automate

  If you’ve ever tried to round numbers in Power Automate, you have probably already run into the issue there […]

Read the Article

Manage U.S. Use Tax on Purchase Orders in Dynamics 365 Finance and Operations

  Managing sales tax requirements on your business purchase can be complicated, but Dynamics 365 Finance and Operations can help […]

Read the Article
5.19.22 Dynamics CRM

How to Write a Great Support Ticket in the Stoneridge Support Portal

Submitting a support ticket through the Stoneridge Support Portal is a quick and effective way to get assistance for any […]

Read the Article

Managing Your Business Through Uncertain Times Using Dynamics 365 Finance and Operations

  Dynamics 365 Finance and Operations (F&O) can help you make informed decisions on how to move your business forward. […]

Read the Article
5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!