nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Portfolio Level Week-to-Week Changes

Nikki G

Hello!

Is there a report and/or a way to show week-to-week changes for all projects across the entire portfolio?

Thank you,

Nikki

Find more posts tagged with

Comments

Antonie B

Hi @Nikki G ,

There is not really an out-of-the-box function, what I have done in the past is to create a sheet in the Project Toolkit (What I call the folder that houses all the templates) with a row that captures the metrics you want to capture week over week.

I then create a copy row automation (https://help.smartsheet.com/articles/770589-copying-a-row-to-another-sheet) to send this over weekly, creating a record/audit log of sorts. This can then be pulled into a report, where you can then report or chart this data. You will need to add a date column to the metadata sheet to capture the date. I use "Record a Date" to record today's date daily on the sheet. (https://help.smartsheet.com/articles/2481986-work-record-date-action)

Hope this helps?

HockinsonJohn

Hi @Nikki G ,

We ran into this same challenge and I built a solution that works well across multiple programs. Here's how we approached it:

Snapshot Sheet Method – I created a weekly snapshot sheet that logs key portfolio metrics (like % Complete, At-Risk Projects, Delays, etc.) every Friday using a helper workflow and a simple "snapshot row" per project.
Automation – Smartsheet automation copies data into the snapshot sheet at a set time weekly, so it’s hands-off once built.
Portfolio Rollup Dashboard – We pull the data into a dashboard showing week-over-week changes using chart widgets and summary reports for visual tracking.

Bonus: If you're using Control Center, you can template this process and apply it portfolio-wide easily.

Sign in to join the conversation!

Quick Links

Trending discussions

Permissions Change
I cannot explicitly add myself as Admin because I'm already the Owner of the Workspace. The AI chatbot said I need Smartsheet Support to manually align my Owner status with Control Center’s Admin requirements for provisioning. Can someone please help?
Looking to track multiple projects
Hello all, I'm new to SmartSheets so I figured I'd throw this question out there and see if SmartSheets would be a good fit for me. My team is looking to track multiple projects to guage overall project health across our environment and present this general project health in a dashboard. Our hope is to send out forms to…
Why is my Global Update putting this new profile data row in the wrong section of the active project sheets?
I am trying to run a Global Update to add a new summary row to existing/active project sheets and it keeps inserting the row in the Instructions section of the target sheets, instead of in the Summary section. Here are the details of my update: I have already manually created the new summary row in the template sheet…