Aggregating rows from multiple project plans into a multi-column summary

I have a bunch of project plans sheets that all follow the same template. Each plan sheet has a rows with key milestone dates:

Start Date
Completion Date
Target Publish Date

Each of the above is in a different row in the project plan sheets.

I want to roll these up to create a content pipeline sheet like the one shown below that aggregates the key dates from all of the project plan sheets. Currently this is done manually. Is there a method to automate it?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you using Control Center?

3blazeP

No, I am not using Control Center. Would this solve my problem?

Paul Newcome

It should from the sound of things. Otherwise you are looking at manual linking (as you have found) or something through the API.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.