Control Center Portfolio Report - Orphaned Data

Hello community,

I'm new to control center and will attend the blueprint class next week. The Smartsheet services team created our portfolio solution and I own administrative responsibilities for the solution.

We have a dashboard portfolio summary report that links to portfolio metrics report, it's searching for completed projects (status = complete within the current fiscal year). We had two test projects which were marked complete and archived which have been purged from the system.

The portfolio metrics report has no projects that match the criteria, yet the dashboard portfolio summary report still thinks we have 2 projects matching the criteria.

How does one remove said orphaned data from the dashboard portfolio report safely?

Apologies for the newbie questions ahead of taking the courses.

Thank you,

Josh

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Josh Burack

I hope you're well and safe!

Is it showing the archived projects or something else?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Josh Burack

Hi Andree,

It is showing a value of "2" which was the value of two test projects which were archived previously, and the archived data was removed prior to go live (so we did not report 2 complete projects incorrectly). Meaning, there is no archive data in the archive reports, no data in the portfolio metrics report, yet the portfolio summary report "thinks" there are 2 completed and archived projects.

It's like the summary report captures a piece of data from the portfolio metrics report and only adds to the column total and never re-evaluates the child report for an accurate total. Hopefully that made sense.

Best,

Josh

Andrée Starå

@Josh Burack

Strange!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.