Project Plan Reports

Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible?

If not, is there a formula that pulls the task name that I can do?

Find more posts tagged with

Formulas

Project Management

Accepted answers

All comments

Paul Newcome

You would need a helper column on each project plan that flags the oldest incomplete task. Then you can create a row report that pulls from all project plans and is filtered to show only the rows that are flagged.

swaldon2

@Paul Newcome Would the "flagging" be manual or is there a way to automate it? Here is a picture of the project plan to help.

Paul Newcome

You can automate it with a formula. I'd be happy to help with one, but there are a number of different ways to interpret "oldest". What is your logic?

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.