Combine tasks from different sheets into a single calendar view

Joe Kovacs

How do I combine tasks from different sheets into a single calendar view? I have my sheets broken out by niche within my firm. I'm the marketing director of a CPA firm with oversight of marketing many niches; I'd like to see all daily responsibilities in a single calendar view. Is that possible? Thanks. Joe

Brett Evans

Joe,

 

I the sheet have columns in common, you can do this using a report that brings in all therelevant sheets. Then you can look at that sheet in Calendar view.

 

Hope that helps,

Brett