1.1 We manage multiple projects, each one of them with its own calendar of events (specific to that project and independent from the other projects)
1.2 Each project-specific calendar is on a different project-specific doc
1.3 Events can be of different “types” (color-coded for easier viewing)
2.1 We need a consolidated view of calendars (a “master calendar”) that is kept synced with all project-specific calendars. Syncing is one-way: changes would be made only on the project-specific calendar and that change needs to be updated on the master calendar. No real-time required for syncing - end of day syncing is fine
2.2 The master calendar should keep info on event type and which project the event is for
2.3 We need to be able to keep adding more projects to sync the calendar with
I am thinking of using cross-docs and automation to push changes (add/modify rows) to a master table for 2.1 and 2.2. I am not completely sure how I will handle events beind added or deleted, so it will be trial and error as it often is…
For 2.3 I am guessing that the push info logic gets copied from the project calendar template used to create a new doc for the new project and no changes on the receiving end (the master calendar) will be needed.
Any better ideas to do that?