Forum Discussion
How to create a shared company calendar for time off and holidays?
I'M LOST I have spent DAYS trying to figure out some way to provide a shared company calendar with Holidays, PTO Schedules, On-Call Schedules, etc. We just want one place to see what's going on ...
careyjm @Anthony-123 Did either of you figure this out? I am looking to do the same thing. What I really would like to do is create a calendar for each Department (that way each manager can just see their department) and then have those roll up into a Company-wide Calendar that could be displayed on our SharePoint Intranet site so anyone in the company can see who is in or out of the office and our Company Holidays.
I can offer an update but I'm not 100% confident about it.
It seems like I can create and manage calendar events for Groups and SharePoint sites but not for a Team. All of our Groups are in Teams so I *think* the calendar only works if you create a Group then migrate it to a Team.
So, if I'm Outlook online and I go to People/Groups that I own or manage, this is the list of 'things' I can use for Calendars. I don't see any Teams here so I can't use them for Calendars (not cool).
I have a Company Calendar from a Sharepoint site (domain.sharepoint.com/sites/CompanyCalendar). I can put Thanksgiving on the calendar and this shows up in Calendar under Groups > Company Calendar. I can also drop this calendar into any(?) SharePoint site/page using the Calendar widget. I have this widget on our main Sharepoint site for everyone to see upcoming paid holidays.
In your case, provided each of your departments has their own Group or Sharepoint site, you should be able to do the same. So maybe on your Sales Department site you'd have the Sales Department Calendar and also the main Company Calendar.
I'm not seeing a good way to combine or collate calendars. Ideally, there would be one calendar showing holidays, closures, corporate events, PTO requests, etc. I haven't looked into it but I'm wondering if a unique Group (All Calendars) can subscribe to all these calendars so it could be displayed in a comprehensive SPO site widget.
Would love to get some feedback from anyone who could investigate these findings on their end.
Oh - I'm just re-reading my original post. I've completely given up on integrating with Apple products LOL. From my perspective, the calendar is available only in Outlook and a SharePoint widget.
- I am trying to figure out how to use power automate to have all OOO events pull to a vacation calendar in outlook that would also update if someone changed their OOO event later. Theoretically, I am sure it is possible, but I'm at a beginner skill level with these tools. Has anyone tried this?
- I would like run SQL to dynamic generate .ics for each departments to share calendar.
https://club.excelhome.net/forum.php?mod=viewthread&tid=1603524&extra=&mobile=&_dsign=7d133e2a
http://e.anyoupin.cn/ics?table_name=%E8%BE%85%E5%AF%BC%E7%8F%AD%E6%98%8E%E7%BB%86%E8%A1%A8I am trying to figure out how to use power automate to have all OOO events pull to a vacation calendar in outlook that would also update if someone changed their OOO event later. Theoretically, I am sure it is possible, but I'm at a beginner skill level with these tools. Has anyone tried this?
I am trying to figure out something like this as well. Ideally, I would like a calendar that pulls from individual calendars and only shows items where people are out all day. That way, staff can use their calendars as they typically would, and when they are out for the day, the group calendar shows only those days. This could also pull from a generic holiday and office event calendar to display standard days off. We currently use different software for this, but it seems like it would be an essential addition to Outlook. Most businesses would want an easy way to see which staff are out of the office for the day.
