Task Rollup Calendar
This blog post applies to SharePoint 2010, 2013, and Office 365. This is enterprise, standard or foundation.
This is a cool little trick that Corey Emmons figured out. Since he doesn’t have a blog, I figured I’d at least document it so that you all can see how smart he is.
The idea is that a task rollup is needed in SharePoint 2010.
(If you happen to have the enterprise version of 2013, then each person does automatically have their own task rollup on their “About Me” site.)
First of all, this is what the end result looks like. A rollup from multiple task lists on different sites. Different task lists have different color codes:
Here’s how to do it:
- Create a calendar, and it doesn’t necessarily have any appointments in it. Mine is called “Test Calendar”. This is something that you may want to create at the root level of your site, so that it’s a central location to see items rolled up from multiple sites.
- Create a task list. Mine is just called “Tasks” and lives at the root level of the site. Create some test tasks in it, and be sure to fill in the start and due dates.
- In “Tasks”, click to create a new view. On the screen where you choose a view format, click Calendar View.
- Name the view “Calendar”. Make it a public view. For time interval, I decided to choose Start Date as my beginning point, and Due Date as my end point. It’s up to you, you can choose any date fields at all.
- Go to (or create) a task list on a different SharePoint site in the same site collection, or a different task list on the same site. On mine, the list is called “Tasks” and it is on a sub site called Demo. Repeat steps 3 and 4.
- Navigate back to that calendar that you created at step 1. Click the Calendar tab in the ribbon.
- Click the Calendars Overlay button.
- On the Calendar Overlay Settings screen, click New Calendar.
- Name it something that indicates the name of that top level task list. I’m just going to call this one Tasks 1. Pick SharePoint for the type of calendar. Pick a color, and then put in the URL of the site where your first task list is. Click Resolve. After you click resolve, the list drop-down will have choices in it. Any type of list or library that you’ve created a calendar view on will be there to pick from. Pick your task list. For the list view, pick Calendar. Check the box to always show, and click OK.
- Repeat steps 8 and 9. For step 9, pick a different color this time. For the Web URL, use the sub site where your other task list is. Click Resolve and pick your sub-site’s task list and Calendar view.
Done! Navigate back up to your calendar. (Mine is called Test Calendar) Now you can see the tasks from both task lists on the calendar, and they span across the days from when each task starts and each one ends. Of course, you don’t have to use the start date and due date, you could just use the due date for both start and end if you want, or any other date field.
Here’s the cool part… you can do this for ANY lists or libraries, as long as you’ve created a calendar view on them!! This works cross-site, within a site collection, but not across different site collections.
Well what do you know! I just found out that Jennifer Mason blogged about pretty much the same thing a while back! SharePoint 2010- Using the Calendar Overlay to Display List Items based on a Category
Thanks for the shout-out!
This is quite a powerful feature. We use it to track release calendars for multiple software products. Be aware that the maximum number of calendars you can overlay is 10!
I attended an online workshop on EndUsersSharePoint with Mark Miller and Laura Roger back in May 2010 that was called ‘Dynamic Form’ in SharePoint 2007. I was wondering if this can be done in SharePoint 2010. I have searched the internet and can’t find anything that looks the same.
We were probably doing something with InfoPath, but I don’t know what. Feel free to browse all of my posts in the InfoPath category, and look at my YouTube channel to find what you’re looking for.
I’ve been working on the project/gantt view with a calendar for awhile. All is working fine, except when I add the gantt view as a webpart to the page where the Calendar is displayed. For some reason, I cannot move to the next month when the gantt view is displayed in a webpart. If I remove the gantt view webpart, the calendar works fine. My VP would like both displayed on the same page so that those who like to look at in calendar view can, and those who want to use gantt can also. Do you know why it does this?
(I don’t have a twitter account unfortunately)
Sorry, but calendars and a lot of other list types act strangely when other web parts are placed on the same page. I would just try creating a blank web part page and try the same thing and see if you have any luck. I wouldn’t be surprised if it doesn’t work, though. 🙁
Thanks for the post. I have an additional question. When you create an events app the default calendar view you get allows the calendar overlay and also has the ability to click on the calendar to add events. However, if you create a task list the calendar view that you get doesn’t provide the easy click on calendar to add events functionality. Also no calendar overlay. Also it is possible to link a timeline to the tasks list (even if you add events as a content type) but not to the events list. Could you please confirm I am not missing anything? is this a built in limitation? Thanks, Dylan