Yearly Calendar with Colors

[Kat_Veliky]

I need to create a yearly calendar that shows each event that happens during the month.
The entire year needs to be printed on one page.
Each event needs to be color coded to show the person assigned to the project. (There are cases where more than one person is assigned to the project.)

We need the months going vertically and the days of the month going horizontally.
We’ve tried Gantt Block. The issue is that color does not allow multiple colors.
We’ve tried Calendar View. It doesn’t allow you to view an entire year or see multiple colors.
Linking to Outlook doesn’t allow the ability to print the entire year.
Linking to Google doesn’t allow to the colors to be assigned.
The timeline is too large to print and has the same issue with colors.

Any thoughts or suggestions would be appreciated. Thanks!!

This is the current version we do in excel. We’d like to have this done automatically via the Airtable information.

[Nicole_McKenzie]

Did you ever find a solution for this? We are in the same boat where we are doubling up with Airtable and Excel as Airtable can't achieve what we need.